SQLEXEC()

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Spiegel (jspiegel_at_YETANOTHERSPAMHATERc-comld.com)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 10:37:45 -0600

Hi All,

I'm essentially a newbie when it comes to using the SQLCONNECT-related
functions. I'm connecting up to an Oracle system sort of like the
following...

nX = SQLCONNECT("eprd", LoginID, LoginPassword)
IF nX > 0
    SQLEXEC(nX, "SELECT * FROM SomeTable WHERE SomeKey = 10",
"curSampleData" )
    IF USED("curSampleData")
        * do stuff
    ENDIF
ENDIF

curSampleData never comes into existence. The next theory I'm testing is a
need to set the Asynchronous property .F. Any other places to look?

TIA,

John