SQLite Explorer troubles
Publicado: Mié Sep 05, 2007 4:45 pm
Dear developers,
first of all many thanks for the new version of this great tool.
Concerning the SQLite Explorer I have two problems to report:
1) When creating a new table (or index) the cell editor does not accept
underscores ('_').
2) The second problem is really a strange problem. When I query the sample
database with " SELECT * FROM customer WHERE state='ME' " no records are
selected. It works fine if I change it into
" SELECT * FROM customer WHERE state LIKE 'ME' ".
However, when changing the var type from CHAR to VARCHAR and back using a
different tool -SQLite Expert Personal - the queries return the result what
I expect.
I don't experience this problem in my Xailer applications if I create and
populate tables in code via the TSQLiteDataSource class methods.
BTW, I also use TMySQLDataSource for querying MySQL databases. I first ran
into troubles untill I discovered that I had to rebuild a new library from
libmySQL.dll (version 4.1). The lib file as provided by Xailer is probably
derived from a different MySQL-version.
As far as I know this info is not mentions in your docs.
Regards,
Stephan
first of all many thanks for the new version of this great tool.
Concerning the SQLite Explorer I have two problems to report:
1) When creating a new table (or index) the cell editor does not accept
underscores ('_').
2) The second problem is really a strange problem. When I query the sample
database with " SELECT * FROM customer WHERE state='ME' " no records are
selected. It works fine if I change it into
" SELECT * FROM customer WHERE state LIKE 'ME' ".
However, when changing the var type from CHAR to VARCHAR and back using a
different tool -SQLite Expert Personal - the queries return the result what
I expect.
I don't experience this problem in my Xailer applications if I create and
populate tables in code via the TSQLiteDataSource class methods.
BTW, I also use TMySQLDataSource for querying MySQL databases. I first ran
into troubles untill I discovered that I had to rebuild a new library from
libmySQL.dll (version 4.1). The lib file as provided by Xailer is probably
derived from a different MySQL-version.
As far as I know this info is not mentions in your docs.
Regards,
Stephan