Asynchronous queries in UniDAC

LIX · Post by **LIX** » Tue 01 Mar 2011 03:30

Hello, I'm examining UniDAC and have a couple of questions about TUniQuery.
1) TADOQuery has a property ExecuteOptions which is a set of eoAsyncExecute, eoAsyncFetch, eoAsyncFetchNonBlocking, eoExecuteNoRecords. Does TUniQuery support similar functionality for asynchronous execution? If it does, then how can I turn these options on and off?
2) TADOQuery also does have a property CursorLocation which can be set to client side or server side. What is the analogous property of TUniQuery?
Is there any functionality of TADOQuery which TUniQuery doesn't have support of?
Thanks in advance.

AndreyZ · Post by **AndreyZ** » Wed 02 Mar 2011 11:23

Hello,

1) UniDAC doesn't have equivalent for the ExecuteOptions property in ADO, but you can use the FetchAll and NonBlocking properties to obtain similar functionality.
2) UniDAC doesn't have any equivalent for the CursorLocation property, because the location of a cursor is defined by its name. If you want to work with cursors, you should use specific components, for example, SQL Server Data Access Components. There is the CursorType property in the TCustomMSDataSet components.

LIX · Post by **LIX** » Wed 16 Mar 2011 05:48

Hi again.
May be a silly question, but... where is located this Nonblocking property, you were talking about? Documentation says TUniQuery doesn't have anything like that. And also there is nothing in help on SpecificOptions. So I'm kinda confused.

AndreyZ · Post by **AndreyZ** » Wed 16 Mar 2011 12:52

Sorry, for the time being TUniQuery doesn't have the NonBlocking property. This property is available in server-specific DAC products, for example, in SDAC. We will investigate the possibility of adding this functionality in the future.