Devart Forums

Why does the TMyQuery create a new(internal) connection to get values on FetchAll = False? I've had problems with transactions... I update some values but I can't get them on transaction...

Can I set some property to cancel this creation?

Tato.

It's impossible due to MySQL server protocol restrictions. You can read details in MyDAC help.

Hi,

I create a new class of TMyQuery and I put the code above in constructor create:

Unidirectional := True;
FIRecordSet.SetProp(prCreateConnection, False);

It seems that this solve my problem, but I've not tested it on totality. I'm not using thread and I only open TMyQuery, populate other dataset, and close TMyQuery. I don't connect controls on TMyQuery. Unidirectional(FetchAll=False) property is important to save memory.

Could I have future problems?

Sorry for my poor english.

Thank's

Tato.

> Could I have future problems?

Yes, it's possible. MyDAC wasn't developed to work in this situation.

Hi,

I want to read all data from a big select, consuming less memory as possible, with a good speed. I don't have plugged controls. Resuming: Select, read and close... But I have to use transactions, locks, etc... in this environment.
Which is the best practice for it using MyDac?

Thank's,

Tato.

Try to use MyConnection.Pooling.