AVFPsql procedure execute

Topics: Developer Forum
Apr 29, 2013 at 5:36 AM
Hi claude,

I have a query re. the "execute" procedure in avfpsql class.

This procedure is designed to call sqlexec twice.
If the first sqlexec fails, the procedure fires login() and tries to sqlexec the same statement again. However, in this second try, where can it go to sqlcommit()?. The sqlcommit is under ELSE loop and will fire only if first sqlexec returns a non negative number.

Therefore, if the first sqlexec fails and second succeeds, where can it find sqlcommit()?

Vivek
Coordinator
May 1, 2013 at 8:25 PM
Edited May 1, 2013 at 10:04 PM
I don't know off the top of my head. My advice would be to search the discussions here and look at the source. For example I just searched for SQL and found:
http://activevfp.codeplex.com/discussions/362763

You can also browse the SQL Class source code and either realize your mistake or make a fix:

https://activevfp.codeplex.com/SourceControl/changeset/view/102314