Re: SQLEXEC()

From: Trey Walpole (treyNOpole_at_SPcomcastAM.net)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 11:33:56 -0500

Check the return value for SQLEXEC()

e.g.,

nRetVal= SQLEXEC(nX, "SELECT * FROM SomeTable WHERE SomeKey = 10",
 "curSampleData" )
IF nRetVal <0
    ** a connection (db) error occurred
etc...

"John Spiegel" <jspiegel@YETANOTHERSPAMHATERc-comld.com> wrote in message
news:eJ1N4tiJEHA.2680@TK2MSFTNGP11.phx.gbl...
> 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
>
>

Relevant Pages

  • Re: SQL-Zugriff auf Access
    ... Die Fehlermeldung tritt im ersten SQLEXEC und nach überspringen auch in den ... >> * fehler ... >> ENDIF ...
    (microsoft.public.de.fox)
  • Re: newbie to perl
    ... > This may seem to be a bit complex for a newbie, ... use warnings; ... use strict; ...
    (comp.lang.perl)
  • Re: SQLEXEC()
    ... and then use AERROR() to get the error message that was returned by the ... > Check the return value for SQLEXEC() ... >> ENDIF ...
    (microsoft.public.fox.programmer.exchange)
  • newbie to perl
    ... This may seem to be a bit complex for a newbie, but I'm looking for some ideas as to how to go about this. ... if the first token is the word Font ... Even if someone can point me to a resource where I can learn how to do this it would be better than me spinning my wheels for hours trying to figure it out on my own. ...
    (comp.lang.perl)