Results 1 to 6 of 6

Thread: Deterine if an SQL statement failed or returned a warning ?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    Brazil
    Posts
    4,188

    Default Determine if an SQL statement failed or returned a warning ?

    cSQLStatement class has SQLExec and SQLExecDirect procetures. They are not functions, so they has no return error code..

    How can we assure the statement got executed succesfully ?

    Only by checking (err) global variable ?

    Code:
     Send SQLExecDirect of hoStatement sSQLDel 
     If (Err) ....
    What if the SQLCODE/SQLSTATE returned by the database engine in not a real error, but just a warning instead, which in some/several cases can just be ignored ?

    I feel that just relying on (err) variable is not much "reliable". (sorry by the wording..., but that's exactly what I mean... )
    Last edited by Samuel Pizarro; 17-May-2022 at 06:35 PM.
    Samuel Pizarro

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •