FAQ Database Discussion Community


Asynchronous TADOQuery's OnFetchComplete not synchonized to main thread

delphi,asynchronous,delphi-xe4,delphi-xe8,tadoquery
When using TADOQuery with [eoAsyncFetchNonBlocking] and attaching to OnFetchComplete event I found that OnFetchComplete is not executing in the main thread (tested in XE4 and XE8). I assume this a bug*, since most of us will do work in the UI on these type of event. I believe this to...

Delphi TADOQuery: Format data before SavetoFile

delphi,tadoquery
I have an application that allows a user to run a query over a remote database using a TADOQuery component. The query results are then saved to an XML file using the TADOQuery's SaveToFile method. I've recently run into an issue whereby if a line feed character (hex "0A") exists...

Delphi - Why am I getting this Access Violation? Is there a limit to ADOQuery parameteres?

delphi,access-violation,tadoquery
I have this code that is returning an Access Violation ('Access violation at address 74417E44 in module 'sqloledb.dll'. Read of address 786E3552') and I can't identify where is the problem. My only guess is that ADOQuery has a limit for the number of parameters we can pass. The code is...

Delphi TADOQuery Select top N

delphi,tadoquery
I am trying to select only the top N items in a TADOQuery, but it gives me and error when I activate the query. It seems to find the top parameter just fine, but fails to replace it when executing. If I don't limit the SQL statement with "Top N"...