Hi,
I want migrate from DBF to SQL. Now I test working with MS SQL Server. For read/write to tables, I use ODBCDBE from Alaska. It's important for me working with transaction. But here I find an small problem: when I use for example three diferent tables using SQL query like "SELECT * FROM..." etc. (all in different Select()) and for example add one record to table in SELECT 1 (with beginTransaction... endTransaction) I must close and re-open tables in SELECT 2 and SELECT 3, even thoug I do nothing here.
If I not close and re-open (with query), when I want move to another record in SELECT 2 or SELECT 3, program crash with error.
Is this typicall or make I some wrong?
Piotr