I have found that using SPT to send a simple rollback like
SQLEXEC('ROLLBACK')
causes C5 error in VFP.
"William Yu" <wyu(at)talisys(dot)com> wrote in message
news:djtrl7$31ir$1(at)news(dot)hub(dot)org(dot)(dot)(dot)
> Andrus wrote:
>> Can you use Postgres savepoints from VFP ?
>>
>> sqlexec('ROLLBACK TO mysavepoint') and even sqlexec('ROLLBACK') cause
>> C5 error.
>
> I have no experience w/ savepoints yet. However, I will say that sometimes
> ODBC will hijack your commands and alter them so you may want to try
> turning off all possible options.