Page 1 of 1
NonBlocking has not effect when using with SQL Azure
Posted: Mon 01 Aug 2022 07:05
by andrewmiller
Hello,
Before open a query,
I set Query.SpecificsOptions.Values['NonBlocking'] := 'True'
but it has not effect and blocking main thread.
Regards
Re: NonBlocking has not effect when using with SQL Azure
Posted: Wed 10 Aug 2022 12:23
by pavelpd
Hi Andrew,
Thanks for your request!
In NonBlocking mode UniDAC receives the result of the request (record) in a separate thread, while the execution of the request and waiting for the response is performed in the main thread.
You can find description of the NonBlocking option via the link:
https://docs.devart.com/unidac/using-sqlserver.htm
In case you need the complete execution of the request in a thread, then you need to create a separate thread yourself, using the TThread class.
A description of the TThread class can be found in the official Rad Studio API Documentation (
https://docwiki.embarcadero.com/Librari ... es.TThread )