Search found 4 matches

by TheBlackSheep
14.02.2013, 22:24
Forum: ADO
Topic: Lazarus, Zeos and Ms Access (mdb)
Replies: 24
Views: 19165

Don't know if anyone has looked into this recently - I have need to populate an MSAccess database (ideally via ADO) and although this is available in Delphi via Zeos it still isn't an option in Lazarus on Windows. If the outstanding issue is an open source OleDB unit then there might be a possibilit...
by TheBlackSheep
03.03.2008, 20:56
Forum: SQLite
Topic: How to create a database in memory?
Replies: 5
Views: 2711

Hi Rüdiger that's easy, drop a zeos TZConnection component on a form or datamodule and set the database to ":memory:" (without the quotes " " of course but both colons ( : ) at each end are important. Set the "Connected" property to true and just point the TZQuery/TZRea...
by TheBlackSheep
02.03.2008, 13:42
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Parsing SQL to get fields & tables
Replies: 2
Views: 1456

Hi Mark I needed a farily quick solution so I've hacked a combination of the code above to get the initial field list and table list and then re-iterate through the list of the tokens from the TokenizeQuery function. In the first instance adding the identifier following a "JOIN" statement ...
by TheBlackSheep
27.02.2008, 23:09
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Parsing SQL to get fields & tables
Replies: 2
Views: 1456

Parsing SQL to get fields & tables

Hi I'm wanting to use a dynamic SQL dataset (SQLite ":memory:" dataset) to link to some non-SQL tables which I'll populate into the dataset at runtime. The theory works fine but I need a way of determining the tables/fields before the real SQL is run (as it'll need to populate at this poin...