Zeoslib Portal

Ok, I need to reopen this. If you create a simple application things work. Now I have a main program and a datamodule. In the datamodule I have a db and a query object, linked together. then I have a separate module to create a database if it does not exists. In the main menu you can select this mod...

Ok, I should have tried this immediately. I just created a small project and guess what? Things are working. That means that I am doing something stupid in my project.... but realy don't know what....

However, it seems not to be a zeos problem :-)

Sorry for the trouble.

Ok, I uninstalled everything, including zeos. Reinstalled Lazarus. Installed Zeos. Recompiled IDE. Error persits. In the next code the database and tables are created, but as soon as the select is executed then the error comes up: 'create table if not exists phsp_pref ('+ 'sectionId varchar(32),'+ '...

Database is set to the path and name of the database. Connectiontype is sqlite or sqlite-3 (both give same error). If I use a ttable or use create table with tquery it works well, but if I use select statements I get the error. If there are fellows who do not have issues with Zeos on lazarus as mmvi...

I'm running under Windows 8. Long time ago I wrote my own Delphi components for sqlite, and I recognize this message. It has something to do with calling the api out-of-sequence. I wasn't able to debug, but I'm not sure I'm the only one with the problem. I tested the readonly version, but this gives...

I can connect to a sqlite database and use the ttable component. However if I connect a TQuery every select is generating error: sql logic error or missing database I can use create table with tquery though. Anybody experiencing same problem? It useually is an sqlite api issue, but I'm not sure. It'...

I was introduced a long time ago in the days of Zeos 4. I have worked with svn before, but mostly I send my remarks to Mark. But I don't mind making the changes into the branch myself. I don't need to wait for a done job
I need new credentials though.

It's been a while I used Zeos. Nice to be back here. I looked at the latest version in Lazarus 1.0.4. Install went well. But if I want to select a table then using the pulldown of tablenames generates an error. GetTableNames also generates an error. Now it's obvious to think that it's because of MyS...

It is possible but not out-of-the-box within Zeos. You need to use a wrapper for that as it is possible to define a callback while executing. See sqlite.org for details.

Albert

Most likely, since working with sqlite is pretty much the same as MySQL etc.

albert

Just a few cents. All databases have their own specific features. It would be great if it was possible to have a 'db' component allowing this. Adding db's to the form allows a dbgeneral component to list the available db's. This way, the footprint can be as low/high as needed. If there's an 'empty' ...

As of version 3.2.5 unicode filenames are supported in SQLite. Therefore the code should not be altered imho. This might be different for D2009 though.

Yes, but you need to delete all source, and bpl's from any directory to be able to re-install. But before you do, if it installes well, look into the components options. Is Zeos mentioned there? If it is, does it's checkbox being checked? If not then check it and all will be well.

Are you using a free Delphi edition. It looks to me that the db vcl is not licenced. Do you have the regular Delphi TQuery, TTable and TDatabase components in your component pallette?

It would require a complete new design. Preferable DB components with a dll property connected to a master DB. This approach I had suggested ages ago. Advantage would be that if you only need MySQL, you could omit the others and thus have a smaller footprint. But it would require a lot of work.