Can you "Reset SQL" at runtime?

[lester50]

We have customers running on different version of a Sybase database, and some reports appear to hang. (The reports were designed and saved against db version 5.0 and the client tries to run it against db version 7.0)

We can solve this by opening the report with the newer database going to the Show SQL Query window and clicking 'Reset'. The report then runs fine.

Is it possible to perform this reset automatically at run-time using the CRADRT? I already have commands to reset the location, although the DSN and server name (and driver for that matter - P2SODBC.DLL) do not change - it is only the database itself (and the odbc driver) that are different. CRADRT may see they are the same and not force a reset....

Any thoughts? Is there another reset or step which may resolve this?

Thanks in advance,
jlester@lester.com

 

[kenhamady]

The SQL statement is not saved with the report (unless you modify it), it is generated after it connects to the ODBC driver. If you have modified SQL, try reseting the SQL and re-saving the report. Otherwise, I am not sure why it wouldn't pick up the new ODBC driver's SQL. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)