>Dmitry,
>
>If you wan to use SPTexec() then do the following
>
>?SQLSETPROP(lnHandle, 'Transactions', 2)
>scan
>?sqlexec(lnHandle,"insert table (col1,col2) values(?col1,?col2)"
>endscan
>if SQLCOMMIT(lnHandle) < 0
> aerror(....)
> ?sqlrollback(lnHandle)
>endif
>
>
James,
I was actually reading last night the chapter in the C/S Applications with VFP book on Transactions. I want to try this approach too.
Thank you very much for your message and sample code.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham