SQLite Admin for AIR 1.0

Thank you a pleasant read, interesting and informative.

Excellent read, I am really impressed

I really love this post anyway and i hope you to improve your quality of article
regards

I am seeing what appears to be a bug with SQLite in Adobe Flex and in SQLAdmin, as follows:

select t1.id, t1.descrip, t2.title
from t1 inner join t2 on t1.id = t2.id
where t1.desc like “xxx%”

t1.id is integer ; t2.id is integer; t2.title is varchar

The problem is, the correct rows from t1 are returned, but t2.title is always incorrect.

When I examine the t2 table to determine the PK value of these wrong titles, I notice that the PK values are very close to t1.id. For example:

t1.id = 140 and the wrong title has a PK of 1400.
t1.id = 2530 and the wrong title has a PK of 25230.
t1.id = 160 and the wrong title has a PK of 1610.

It looks like a number column is being sorted as text. Perhaps an index is being turned into an array and sorted as text rather than as int?

Please note than when I execute the identical query in other GUI query tools that work with SQLite (e.g. Razor, Visual Studio, SQL Maestro) they all agree with each other and return the correct t2.title values.

I’m still novice at using Adobe AIR and SQLite, but I’m in serious doubt on the SQLite syntax.
According to the reference at : http://www.sqlite.org/lang_createtable.html , the following query should be alright ..

CREATE TABLE `Bluueergwhatever`
(`id` int(11) CONSTRAINT PRIMARY KEY AUTOINCREMENT,
`name` varchar(50))

But while playing around it seems like none of the sqlite syntax match, only the MySQL -like query syntax seems to work. What am I doing wrong ? Help is very much appreciated.

yes agree with

Wonderful Stuff you post!

this is an amazing blog, you are a good publisher, i will return more often to your blog.

Fantastic little app, thanks very much.

Regarding the syntax, I’ve noticed that it’s the quote marks you have to be careful of (i.e. MySQL uses ` with tables whereas SQLite uses ‘ ), but I believe this is an SQLite thing and nothing to do with the app.