unidac with sqlite

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
pwatel
Posts: 39
Joined: Wed 11 Feb 2009 09:42

unidac with sqlite

Post by pwatel » Wed 17 Feb 2010 07:38

Hi
I just starting with unidac (I am a IBDAC user)
I am trying the sqlite DBs
All text fields are considered widememo fields so on any DB grid it is a problem I know in sqlite there is no text size limitations
so it makes sense but the user does not have to know that
on any control it shows widememo
A) is there an option like in ibdac treat blob as text ? or what should I do ?
B) does sqlite supports unialerter or it is DB specific(which I suppose)
C) the trial version does not let me keep my registered components at the same time
i) because it is a trial
ii) or unidac cannot coexist with IBDac
thank you
Regards
PW

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

Post by Dimon » Fri 19 Feb 2010 14:59

1) UniDAC maps TEXT fields to TMemoField or TWideMemoField depending on UseUnicode specific options of TUniConnection. You need to change data type of the field in the database or use any expression with this field in your SELECT query.

2) Currently TUniAlerter can be used only with Oracle, PostgreSQL, and InterBase (Firebird) because not every database server supports event notification.

3) Product compatibility is provided for the current build only. To make UniDAC and IBDAC work simultaneously on the same IDE, you should use the latest versions of UniDAC and IBDAC. The latest compatible versions are the following: UniDAC 3.00.0.6, IBDAC 3.10.0.11.

Post Reply