Can SQLite Access other DevArt DataSet?
Can SQLite Access other DevArt DataSet?
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.
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.
Re: Can SQLite Access other DevArt DataSet?
hello,
This feature is already added to our UserVoice and roadmap. However, we cannot tell the exact implementation time frame.
This feature is already added to our UserVoice and roadmap. However, we cannot tell the exact implementation time frame.
-
- Posts: 13
- Joined: Fri 05 Apr 2013 08:43
Re: Can SQLite Access other DevArt DataSet?
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!
- 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!
Re: Can SQLite Access other DevArt DataSet?
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.
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.
Re: Can SQLite Access other DevArt DataSet?
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.
http://devart.uservoice.com/forums/1046 ... components
http://devart.uservoice.com/forums/1046 ... ql-dataset
thanks,
daniel.
Re: Can SQLite Access other DevArt DataSet?
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.
Re: Can SQLite Access other DevArt DataSet?
Thanks, please inform us, if ready, so we can kill FireDAC SQL Lite from our Project.
Re: Can SQLite Access other DevArt DataSet?
As soon as we have implement in-memory dataset, we will inform you.