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
.
Comments
Post a Comment