flex - SQLite gurus: how can I display very detailed metadata about a file? -

I have a situation where a simple query against the table is returning an incorrect value in Flex, but other GUI front-end

Choose the title from TTL where ttl.ttl = 140 // ttl is also the column name of PK column

is returning the title Is related to a row whose pk = 1400 .

ttl.ttl is defined as int datatype. Again, the problem itself appears only

>

How can I ask internally to help solve the problem?

I'm definitely not a guru, but hopefully some useful information can be provided.

a. Sqlite command line tool

If you are running the sqlite3 command line access program, you can type ".tables" to get a list of all the tables. Or you can type ".schema" to see the entire database schema, including all tables and indices.

B. By code

  SELECT name sqlite_master WHERE type = 'table' by name ORDER;  

View.

---

Edit:

After reading your post on the Adobe Forum, I think your problem is here:

Ttlid should be declared as integer primary key , but INT primary key .

delcaring TTIL AS integer primary key , this will be a nickname for arid which is a self-activation key.

See

.