Here is the problem. My external program builds sql script and places into file my_script.sql Then I execute statement "sqlite3 my_db < my_script.sql" as a system call from my external program. I can check result of execution this statement and it always returns 0 (success) regardless of actual SQL result. I have absolutely no knowledge of my SQL execution status.
Vladimir --- Jay Sprenkle <[EMAIL PROTECTED]> wrote: > On 5/12/05, Vladimir Zelinski <[EMAIL PROTECTED]> > wrote: > > I understand that. Question is HOW I can check if > > statement failed or successful? What variable > contains > > status of the result of execution. > > The return code from the call that executes it. > Are you running SQL via code or from the command > line interpreter? >
