tHanks
I've already found the solution
Phil.
-----Message d'origine-----
De: Reddy, Venkat [SMTP:VReddy@PHOENIXINT.COM]
Date: mercredi 12 janvier 2000 14:57
Ā: SQR-USERS@list.iex.net
Objet: Re: Strange error message
Hi Use -S on your command line you can see all selects and stored procedures. Pick the cursor 18 from log file and test it by Isql or RapidSql and correct the SQL statement.
E.g.
Log file looks some thing like this:
Cursor #18:
SQL = select H.AMT, H.TRAN_CODE, H.POSTING_CODE, H.REVERSAL, H.ORIGIN_ID,
H.CREATE_DT, datepart(YY,H.CREATE_DT), datepart(MM,H.CREATE_DT),
datepart(DD,H.CREATE_DT), H.DESCRIPTION, H.CHECK_NO,
ISNULL(H.CHECK_NO,-99999), H.ATM_LOCATION, H.EFFECTIVE_DT, H.PTID,
H.ORIGIN_TRACER_NO, H.TFR_ACCT_NO, H.TFR_ACCT_TYPE,
H.COMBINED_CODE, H.NO_ROLLED_CC, H.REVERSAL_PTID, 1, 0 FROM
DP_HISTORY H WHERE H.ACCT_NO = @__p1 AND H.ACCT_TYPE = @__p2 AND
H.CREATE_DT BETWEEN @__p3 AND @__p4 AND (H.TRAN_CODE BETWEEN 100
AND 199 OR ((H.TRAN_CODE BETWEEN 600 AND 899) AND (H.AMT != 0)) OR
H.TRAN_CODE IN (955, 995, 972, 982)) ORDER BY H.ACCT_NO,
H.ACCT_TYPE, H.CREATE_DT, H.PTID
Compiles = 2
Executes = 6
Rows = 76
Thanks
Venkat
-----Original Message-----
From: Philippe DAVID [ <mailto:Philippe.DAVID@GLENAT.COM>]
Sent: Wednesday, January 12, 2000 8:38 AM
To: SQR-USERS@list.iex.net
Subject: Strange error message
hello folks !!
My SQR program give me a strange error message:
(SQR 5528) Sybase DBRESULTS error in cursor 18:
(102) Incorrect syntax near '@__p10'.
Error on line 1102:
(SQR 3733) Could not create procedure for SQL.
Errors were found in the program file.
SQR: Program Aborting.
I'm suprised because I don't have any line with '@__p10' in it.
Has someone an explanation ??
Philippe DAVID
Editions GLENAT
6 rue Lt Chanaron
38000 GRENOBLE
33 (0)4 76 88 75 92