Can SQLite Access other DevArt DataSet?

[dschuch]

Hi,

i looked a bit to FireDAC after EMB bought it and this feature is absolutely great:
I can Query DataSets, that are Querie'd from a DataBase. Thats nearly LINQ in Delphi

http://docs.embarcadero.com/products/ra ... l_SQL.html

Is sth like this possible with DevArt? If not i will suggest it on the UserVoice.

Thx.

[AlexP]

hello,

This feature is already added to our UserVoice and roadmap. However, we cannot tell the exact implementation time frame.

[Dunkelmann]

I did something by myself that has similiar functionality, using UniDAC

- Open Database of your Choice
- Open Dataset (Query/Table)

- Use MetaData Information/ Table Info to automatically generate a CREATE statement that resembles the Dataset Stucture. TUniScript ist used for creating this Statement.
- Add Create Index Statements if required

- Create In-Memory or File Based SQLite Database using the automatically generated UniScript

- Use BatchMove to transfer Data from Dataset to SQLite Database

Repeat for every Dataset of your choice.

This leaves you with fully SQL queryable SQLite Database derived from your Datasets.

Works fine for me this way!

[AlexP]

Hello,

Yes, you can use SQLite as an engine for "in-memory DataSet", however, as we currently support the Direct mode for the Win32 platform only, using this approach in other platforms requires supplying the SQLite library.

We are working on the implementation of this feature, and we'll try to support it as soon as possible.

[dschuch]

if i see it right, this is not yet implemented natively, isnt it?

http://devart.uservoice.com/forums/1046 ... components

http://devart.uservoice.com/forums/1046 ... ql-dataset

thanks,

daniel.

[AlexP]

We have just supported Direct mode for all platforms in this version. Now we can implement in-memory DataSet. However, we can't tell the exact implementation time frame.

[dschuch]

Thanks, please inform us, if ready, so we can kill FireDAC SQL Lite from our Project.

[AlexP]

As soon as we have implement in-memory dataset, we will inform you.