MS SQL with ODBC

This forum is for general support of Xbase++
Post Reply
Message
Author
Piotr D
Posts: 131
Joined: Mon Jul 28, 2014 1:26 am
Location: Poznań, Poland

MS SQL with ODBC

#1 Post by Piotr D »

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

Post Reply