Board index » delphi » Function Sequence Error with Sybase
Function Sequence Error with Sybase
2004-10-26 08:44:11 AM
I am struggling with this problem, Sybase 8.5, Delphi 6, BDE, and Crystal
After I previewed a report, a code in the application which simply delete
some records in a table failed with this message [Microsoft][ODBC] Function
The statement was simply like this
'delete from DBA.SomeTable where SomeField = SomeValue'.
The where clause does not return any value, and from ODBC trace I found this
514-4c0 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
This statement runs just fine if I did not run Crystal Reports, the same
application runs just fine with Microsoft SQL Server.
1. Does anyone ever have this kind of error?
2. How can an application (Crystal) change ODBC behavior?
3. I want to see ODBC environment setting before running Crystal and after
running Crystal. but I do not know how to access ODBC handle from within
BDE. Anybody knows?
btw, I have tried installing the latest ODBC driver from Sybase with no