Hi, I did not use sqlcommit() because I did not set my connection property using sqlsetprop to 2 as manualy updates. So I assumed that what I execute using sqlexec will automatically update the remote tables since the connection is set to 1 as automatic by default. How can I fix this problem? do I have to set my connection using sqlsetprop?

thanks in advance...