Zeoslib Portal

seems to be a bug on the zeoslib with tables without primary key field.

for workaround, add an autoincrement pk field to the table, close db and reopen it.

it seems to be an access problem to the database file. take care you have full access rights on the folder where it located / saved.

No sorry, SQLite Administrator uses the ZeosDBO wich have no support for UTF16 encoding.

Where do you lookp the Table Data? At "Edit Data" Tab ... this uses a TZTable Object wich fetches all Data i mean. Try to use a simple query with and without selecting the blobfield. On Simple Querys you also can edit in the Result Grid.

It's a Bug in SQLite2.x

In SQLite3 the Problem is solved.

in the test session yesterday, i always had clear table checkbox checked ... if the checkbox is checked, only a "delete from table" statement is executed before import. You got right, the speed of the import is very slowly. But I have imported 100k rows in 5min on a P4 3,2 HT The import fe...

//Edited...

I have taken the test data you've been posting first. But it doesn't matter...the quotation marks will be removed before importation anyway. Only the data between the separators will be imported.

Hi zdragon,

ive tested with your testdata and it works fine for me.

i have tryed the FieldTypes "INTEGER" and "NUMERIC" for the first two columns.

Wich FieldType has you tryed ?