>Kevin,
>
>One additional question that came to mind and no-one answered for me.
>
>
>If I've got an order with several orderlines and I want to commit the order into one transaction. How would you implement that with SPs ?
>
>In VFP I would use remote views and do something like:
>
>

>INSERT INTO Orders (....) VALUES (....)
>INSERT INTO Orderlines (.....) VALUES (....)
>INSERT INTO Orderlines (.....) VALUES (....)
>INSERT INTO Orderlines (.....) VALUES (....)
>INSERT INTO Orderlines (.....) VALUES (....)
>
>
>SQLSETPROP(Applic.SqlHandle,"transActions",2) && Manual Transaction
>BEGIN TRANSACTION
>IF TABLEUPDATE(2,.T.,"Orders") AND TABLEUPDATE(2,.T.,"OrderLines") AND SQLCOMMIT(Applic.SqlHandle) > 0
     END TRANSACTION
>ELSE
>    SQLROLLBACK(Applic.SqlHandle)
>    ROLLBACK
>ENDIF
>SQLSETPROP(Applic.SqlHandle,"transActions",1) && Automatic Transaction
>

>
>How would YOU implement this with SPT ?
>
>Walter,