Zeoslib Portal

Hello,

Tested with latest svn testing branch. Backticks are ok for me, now.
Thanks for fixing that Mark.

Dominique

Hello,

Tested with latest svn testing branch. Backticks are ok for me, now.
Thanks for fixing that Mark.

Dominique

This hack could also work with other protocol.
But as for example, SQLite does not support table/column name starting with digits except if names are quoted and version is 3.3up. Others engine, I don't know.

Hello, I've already discussed this with mdaems. Mysql describes in its reference manual that a table name may have any alphanumeric char in any order. Here I have some tables named on this scheme : digits + letters. When I try to open it with zeos testing branch, it raises an error. After some debug...

I didn't manage to make GetTableNames work. Instead, I've used TZMetadata components and it gives correct table names.

I haven't got time now to investigate on ZConnection.GetTableNames. hope I will take a closer look later.

More details :
ZConnect.GetTableNames always return a zero count list.
If I tried this 'SELECT TBL_NAME as TABLE_NAME FROM SQLITE_MASTER' with TZQuery then it also returns a zero count set.

It seems to me that I'm lost there 8-|

the blobs are filled with jpeg and png files. They are about 200ko average size. SQLite Administrator doesn't swap as I have 1Go RAM and it allocates a max 11Mo during table opening. But it hits a lot the hard disk. By the way, I use SQLIte admin 0.8.2.6beta. Maybe there is a more recent exe. Anothe...

Ok, I've figured that I should affect 'sqlite-3' to protocol. Now it connects. Second Step, I call ZConnect.GetTableNames but the function returns a zero count list. During a debug step, I copied the SQL string generated by GetTableNames and tried it under SQLite Administrator and ..... it works. Le...

I use Svn testing branch of zeos.
If I don't rename the dll, zeos complains that it can't find sqlite.dll

Hello, I've used sql administrator to connect to a sqlite3 database. my database contains a table image of around 3000 records of 4 fields. the latest field is a binary blob containing the image. If I display all the image table data, it takes a long 30 seconds to show up. How do you explain this ? ...

hello, I'm trying to connect to a sqlite3 databse through zeos component. I have copied sqlite3.dll of sqlite.org in my app dir. Then I've renamed it sqlite.dll. I've affected the protocol property of ZConnection with 'sqlite'. the app compiles but raises an exception reading a nil address during co...

Hello zeos team, I have a fix for compiling zeos testing branch under delphi5/6. Description of bug : ValueFromIndex is a property added to TStringList on delphi7 Here is the svn patch : Index: ZPlainMySqlDriver.pas =================================================================== --- ZPlainMySqlD...

Hello, I'm using svn trunk of zeos and delphi6 to access a Mysql5 server. First problem : TableName If I set TableName to 8Image, zeos raise an error like "table Image does not exist". After some debugging, I found that the tokenizer split the '8' char and the following of table name. Ther...