I have 4 SQL Selects I want to run against an Oracle back end. 2 of them work fine, the other 2 do not. The SQL was designed by an Oracle DBA since I was unfamiliar with the databases. All 4 scripts run fine when I issue them using Oracle Enterprise Mgr SQL Worksheet, but only 2 of them work when I execute from VFP. I'm using VFP 6.0 Service Pack 3. The following is the code:
gnConnHandle = SQLCONNECT('SWORD', 'userid', 'pwd')
=SQLSETPROP(gnConnHandle, 'asynchronous', .T.)
=SQLEXEC(gnConnHandle, lcSQLString, 'Results')
Where lcSQLString is the SQL script mentioned above. I'm storing the SQL in a Memo field in a table, since I have 4 scripts to run now that may change later.
I took one of the scripts that doesn't work and added an additional and statement in the where clause to limit the number of records. When I do that, it works. So I'm guessing that maybe its just timing out. Any thoughts?
Oct 31 = Dec 25