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
In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
SQLite Explorer troubles
-
- Mensajes: 305
- Registrado: Jue Nov 30, 2006 12:17 am