Zeoslib Portal

Yes, I just use Zeos with D2006 to create and use Android DB.
Android Db are sqlite3 simple databases. Use any from your device, put in your Pc and open with any Sqlite manager. You will see the tables. There 1 that will be create always to "use" by Android SO.

Hello:

Please, I need create any function like Pos() inside sqlite. There is sqlite_create_function, but I don't know how to use/translate it to use with Zeos in Delphi.

Greetings: Having a sqlite3.dll in system folders (windows, system32, etc.) has priority than our own distributed application that normally put in the folder for our app. I've noticed this since I have in my app folder is the last of the original distro site sqlite.com yet when I call the function t...

It's less memory consumer, but not mark the diferent. Just we need to adapt to use it in this way, ja.

Thanks

But I need search and update records in database all the time, so I prefer use ZQuery, not readonly datasets.

It´s different varchar(255) and TEXT fields? I mean, about this that you explain with the cache memory?

Thanks.

Sorry, the real name is BoxedApp, not InboxApp.

papelhigienico, give me an email and I'll send you. But if you want, look in Google

Deleting all Ztables and using only ZQuerys I can decrease all the memory consume up to 41Mb.

If you use Absolute Database, the same code and the same database structure and data, it only consume up to 17Mb, including 6 ABSTables opened with MasterSource option betwen them.

Why SQLite consume that?

I still using InboxApp and over x64, all work fine, perfect. The application only increase the side adding the sqlite3.dll size. I try BTMemoryModule, but can´t do it. The best way is using InboxApp.

I have been working with Delphi 2006 + Zeos 6.6.6 and use an encrypted 16Mb database with SQLite3 protocol (about 15000 records).

The executable is about 5Mb, but when a run it, it consume 15Mb, but when I open the encrypted database it use 88Mb !!!!

Why too memory...?

Hello: We have diferents databases, one per month, and we need query from all of them at the same time, for example, how many records are females. Zeos doesn't work like this: SELECT * FROM "path\january.db3".Clients, "path\february.db3".Clients WHERE Sex='Male'; Please we need s...

I solved the problem using InboxApp that simulate virtual files. It's for me, so don't matter if it's trial. But if somebody can do that you said, will be so usefull. I can't do it myself.

Hello: How can I use sqlite3.dll embed inside App as resource? I can use sqlite functions directly using sqlite3.dll as resource, loading with BTMemoryModule, but, Zeos need the file in the root of the app, no recognise it from memory This will be the best for developers, beause Zeos is very helpful...