Hello,
Before open a query,
I set Query.SpecificsOptions.Values['NonBlocking'] := 'True'
but it has not effect and blocking main thread.
Regards
NonBlocking has not effect when using with SQL Azure
-
andrewmiller
- Posts: 1
- Joined: Mon 01 Aug 2022 06:49
Re: NonBlocking has not effect when using with SQL Azure
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 )
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 )