Zeoslib Portal

Yes, attach a real db with table and use simple sql to copy the data. You cannot just 'save'. Then you should consider using a real table in the first place

AFAIK there's no real approach about how the true/false data needs to be stored in any database. However it isn't that difficult to use strtobool and bool tostr because of the standard vars in Delphi: TrueBoolStrs and FalseBoolStrs. Both are of type stringarray and you fill it with the different tru...

Point is, is it the best solution to all databases? Just to save a byte?

I always recommend to fully type out the types. SQLite is of origin typeless and datatypes needs to be emulated. In version 3 there are a few datatypes, but what's the advantage of 'crypling' names, just the few bytes to type or to prevent typo's?

There's no way to address an error like this. What exactly have you done?

There's an error limiting blobs on sqlite within sqlite3.dll. It's been addressed and afaik it will be in the next formal release.

You can't get the same error from sqlite3.exe since this is a typical Delphi message. Why can't the db be opened by sqlite3.exe?

I must confess that I don't realy understand what you want to do. You can using more than one db connection but if you use sqlite then I would advise to use separate databases. Since sqlite locks on update the entire database you might fall in to locking problems. If you have the several databases y...

I've been looking at this but couldn't actually find something. I thought it had to do with the lazaras package?

Appearantly. Other solution is to use the auto-vacuum pragma which is rather new. It's not possible to execute vacuum when a tranaction is open.

ok

OK, I would appreciate a small sample with the problem and I'll look into it. Please mail it to support at aducom dot com without exe.

albert

I've changed it to sqlite 3 and posted it. It probabely will be solved in cvs soon.

Why not: function TZSQLite3PlainDriver.Open(const filename: PChar; mode: Integer; var errmsg: PChar): Psqlite; var Result0: Psqlite; begin Result0:= nil; if (LibVersion > '3.2.5') then ZPlainSqLite3.sqlite_open(PAnsiChar(AnsiToUTF8(FileName)), Result0) else ZPlainSqLite3.sqlite_open(filename, Result...

This does not seems to be a ZEOS general solution to me.