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 )