RE: [sqr-users] SQR strange error.

["Alexander, Steve" <Steve.Alexander@ci.sj.ca.us>]

I think the SQR instructions (like do Grava-Linha-Lancamento) need to be in
the first part of the selection, not in the part after the union keyword.

-----Original Message-----
From: Valmir Tavares de Oliveira [mailto:voliveira@hqs.com.br]
Sent: Friday, August 01, 2003 3:04 PM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] SQR strange error.
Importance: High


Hi All,

   This is my first post to the list.
   The following SQR is give me an error that i donīt understand.

<error>
SQR 5528) ODBC SQL dbexec: SQLExecute error 170 in cursor 3:
   [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near 'Grava'.
(SQR 5528) ODBC SQL dbexec: SQLExecute error 8180 in cursor 3:
   [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be
prepared.

Error on line 191:
   (SQR 3735) Could not execute SQL.

SQR: Program Aborting.

</error>


 Does anyone point me to right direction to figured it out ?

Iīm using  : PeopleSoft 7.7, Windows 2000 Server SP 3, SQR 4.3.2

<SNIPET>
begin-SQL
SELECT B.ACCOUNT,
B.DEPTID,
B.PRODUCT,
B.SG_ATIVIDADE,
B.SG_RAMO,
B.PROJECT_ID,
B.AFFILIATE,
B.STATISTICS_CODE,
SUM(B.MONETARY_AMOUNT)

 FROM PS_JRNL_HEADER A, PS_JRNL_LN B
WHERE A.BUSINESS_UNIT      = B.BUSINESS_UNIT
  AND A.JOURNAL_ID         = B.JOURNAL_ID
  AND A.JOURNAL_DATE       = B.JOURNAL_DATE
  AND A.UNPOST_SEQ         = B.UNPOST_SEQ
  AND A.BUSINESS_UNIT      = $bu
  AND A.SOURCE            <> $source
  AND B.LEDGER             = $ledger_in
  AND A.FISCAL_YEAR        = #fiscal_year
  AND A.ACCOUNTING_PERIOD  = #account_period
  AND A.JRNL_HDR_STATUS    = 'P'
GROUP
   BY B.ACCOUNT,
      B.DEPTID,
      B.PRODUCT,
      B.SG_ATIVIDADE,
      B.SG_RAMO,
      B.PROJECT_ID,
      B.AFFILIATE,
      B.STATISTICS_CODE
UNION ALL
SELECT D.ACCOUNT,
D.DEPTID,
D.PRODUCT,
D.SG_ATIVIDADE,
D.SG_RAMO,
D.PROJECT_ID,
D.AFFILIATE,
D.STATISTICS_CODE,
SUM(D.MONETARY_AMOUNT)
   
   DO Grava-Linha-Lancamento <--- This is a line which error is happening
   
 FROM PS_JRNL_HEADER C, PS_JRNL_LN D
WHERE C.BUSINESS_UNIT      = D.BUSINESS_UNIT
  AND C.JOURNAL_ID         = D.JOURNAL_ID
  AND C.JOURNAL_DATE       = D.JOURNAL_DATE
  AND C.UNPOST_SEQ         = D.UNPOST_SEQ
  AND C.BUSINESS_UNIT      = $bu
  AND C.SOURCE            <> $source
  AND D.LEDGER             = $ledger_in
  AND C.FISCAL_YEAR        = #fiscal_year
  AND C.ACCOUNTING_PERIOD  = 998
  AND C.JOURNAL_DATE       BETWEEN $date_in AND $date_out
  AND C.JRNL_HDR_STATUS    = 'P'
GROUP
   BY D.ACCOUNT,
      D.DEPTID,
      D.PRODUCT,
      D.SG_ATIVIDADE,
      D.SG_RAMO,
      D.PROJECT_ID,
      D.AFFILIATE,
      D.STATISTICS_CODE
ORDER
   BY D.ACCOUNT

end-SQL

</SNIPET>

   I have a function called Grava-Linha-Lancamento.

Sorry for my bad english ;-)

Thanks in advance
Valmir.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users