>create database tovistar
I am not 100& sure, but I think you are setting to manual transactions the wrong connection handle.
>create sql view &mtable remote connection tovistar as select * from &mtable
See, the above has no SHARED in it...so when you do this:
>SELECT 2
>USE (MDATATABLE)
You are actually creating a new connection to the SQL server. I would say either add a shared to the view... or... after you do the above do:
nTestHandle = cursorgetprop('ConnectHandle',mdatatable)
If you compare nTestHandle to nHandle I think they will be different.
So, when you do this:
> sqlsetprop(nHandle, 'transactions', 2)
> sqlsetprop(nHandle, 'PacketSize', 40960)
You are really setting properties of the wrong connection.
Let me know if this is the solution.
BOb