Zeoslib Portal

It is odd, since SQLite does know the fieldtype because it is depending on it's expression. Ormada, could you send a small failing sample to aducom at support dot com, I'll like to look into this deeper. Please keep out exe as you probabely already know

albert

The real reason why it is not working is because it is a general bug. It can be (temporarely) solved by: {** Checks the correct SQL query. } procedure TZAbstractRODataset.CheckSQLQuery; begin if Trim(FSQL.Text)='' then // 20070529 Aducom raise EZSQLException.Create(SQueryIsEmpty); // 20070529 Aducom...

I'll check it out.

albert

If this problem is related to Lazarus then yes....

There is no provider anywhere which will allow you to access your MySQL database from outside the server for obvious reasons. If you do not need to update a lot then you can export sql and import it by using phpMyAdmin i.e. But what I don't see is what Zeos got to do with it.

I'll look into it, but at first sight this is a UTF8 solution assigned to a widechar. The standard for widechar is UTF16 defined by nchar and nvarchar...

Will look into it.

albert

Have you tried the syntax on sqlite3.exe?

In the Delphi components there's a property called 'truth value' in which you can define the boolean value to be treated. SQLite is typeless so the boolean value needs to be emulated like any other field. This is a matter of a deal and not a bug.

There are in Delphi UTF8 conversion routines you might use. If you don't need to be database independent you might want to try one of the SQLite-only wrappers as can be found on www.sqlite.org.

I cannot confirm that, you might want to convert before inserting?

I don't have much knowledge about Linux implementation, but useually the names of the dll's are fixed and you need to rename the dll's (or so's) themself for access. I.e. MySQL is delivering MySQL.dll which need to be renamed to MySQL40.dll, MySQL41.dll etc. This is also the case for SQLite.

Is this the amount of leaked data depending on the amount of data-access or constant?

This is SQLite nature. See www.sqlite.org.

albert

In fact it goes the same as any other components. Open the appropiate packages and install: open -> select borland projectt group -> compile/install. Don't forget to add the appropiate directories of the libraries (every subdir!) to the library path to be found in environment settings. If you are lo...