Unidac features evaluation

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
mauromdq
Posts: 4
Joined: Fri 06 Nov 2009 15:18

Unidac features evaluation

Post by mauromdq » Mon 23 Nov 2009 14:34

Hi,
i want to know how i can evaluate this two items listed on the features section on the Unidac component main page.

# RefreshQuick method [ SQL Server, MySQL ]
# Fast record insertion with TUniLoader component

Is there a way to do fast record insertion with TUniloader component?

Thank you in advance.
Regards,
Mauro

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Tue 24 Nov 2009 09:10

You can try using the RefreshQuick method in the following way:

- place TUniConnection and TUniQuery components on the form, set the required properties and set Active to True for TUniQuery;
- place TButton and call the RefreshQuick method from the OnClick event. If data in the database was changed, RefreshQuick will refresh the data.

You can see how to use the TUniLoader component in UniDacDemo which is located in

\Demos\UniDacDemo

mauromdq
Posts: 4
Joined: Fri 06 Nov 2009 15:18

More doubts

Post by mauromdq » Tue 24 Nov 2009 12:01

First i want to thank you for the quick answer.

About "# Fast record insertion with TUniLoader component " Uniloader demo and component are related with get control over load events. But i think may be FastRecordInsertion feature is no related with it.

I tested QuickRefresh with UniTable component, but im getting and exception. Im loading a mysql table. Then i change the db data with another program. When refreshquick is called im getting an mysql exception. Dbmonitor shows me that the sqlstatement is incomplete " select id_pk from order by id_pk" . You can see that table name is missing there. But if you debug and inspect the Unitable component just before calling that method the tablename is assigned.

Thak you in advance.
Regards,
Mauro

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 26 Nov 2009 11:10

I can not reproduce the problem.
Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill table.

Post Reply