Problem with FetchAll and updates
Posted: Tue 21 Dec 2004 17:37
Hi,
I'm using D5, MyDac 3.1.13 and MySQL 4.0.20a
I'm experiencing 2 problems:
- First, I've
1 TMyConnection
1 TMyQuery
1 TMyTable
I'm in edit mode of the tmytable object, with some edit component bounded. After some hours if I click OK to save changes I have a "Connection lost during query" error.
- Second, and last
1 TMyConnection
several TMyQuery of several tables in database
(all query are very simple, of type "select * from table where")
several TMyTable of several tables in database
Than I've to do some operation such as delete and insert, modify, update on some of this tables.
When I've to make an update I create a TMyCommand and than free it.
Using FetchAll = True, I've no problem, all insert, modify and update works perfectly
Using FetchAll = False, I've the problem that operations stop at the updates (mysql doesn't receive the command).
The 3.0.x component freeze, but the 3.1.13 component after a while says "Lost connection during query"
I need Fetchall = False, to work with grid of large query (select * from table).
Thanks
Lsc82
I'm using D5, MyDac 3.1.13 and MySQL 4.0.20a
I'm experiencing 2 problems:
- First, I've
1 TMyConnection
1 TMyQuery
1 TMyTable
I'm in edit mode of the tmytable object, with some edit component bounded. After some hours if I click OK to save changes I have a "Connection lost during query" error.
- Second, and last
1 TMyConnection
several TMyQuery of several tables in database
(all query are very simple, of type "select * from table where")
several TMyTable of several tables in database
Than I've to do some operation such as delete and insert, modify, update on some of this tables.
When I've to make an update I create a TMyCommand and than free it.
Using FetchAll = True, I've no problem, all insert, modify and update works perfectly
Using FetchAll = False, I've the problem that operations stop at the updates (mysql doesn't receive the command).
The 3.0.x component freeze, but the 3.1.13 component after a while says "Lost connection during query"
I need Fetchall = False, to work with grid of large query (select * from table).
Thanks
Lsc82