I don't know what your specific problem may be but check to make sure that you are using INTEGER [exactly I-N-T-E-G-E-R] primary keys (not INT or any other variant form). I documented on Adobe's bug database and in their AIR discussion forum a problem with the Adobe implementation of SQLite --Adobe is treating INT and INTEGER primary keys as if they were the same, taking both forms as an alias for the RowId, which in SQLite they are not.
Regards Tim Romano On Thu, Apr 1, 2010 at 1:10 PM, Felipe Aramburu <fel...@kwhours.com> wrote: > I have some code that is using flex sdk 3.2 and I am updating and > inserting into a database with the following queries: > > stmt.text = 'INSERT INTO Question( hotlist, name, label, datatypeid, > advanced, multivalue, measurementtypeid) VALUES (@hotlist, > @name,@label,@datatypeid,@advanced,@multivalue,@measurementtypeid );'; > > > stmt.text = 'UPDATE Question SET hotlist = @hotlist, name = @name, > label = @label, measurementtypeid = @measurementtypeid, datatypeid = > @datatypeid, advanced = @advanced, multivalue = @multivalue WHERE id = > @id;'; > > I don't think those are very interesting to the problem but its better > to provide more detail than less. > The program executes these queries without a problem, the view > displays the information as expected and a quick query using the > sqlite command line tool will confirm that such queries executed > successfully and without a problem.. > > The problem arises when I check the database in two different tools > > Lita > Sqlite Expert Professional (SEP) > > Both of these tools show a version of the database that is different > from what i see in the command line and they are equivalent in their > discrepancies (they are different from the command line but the same > as each other). > > So heres the basica scenario: > > 1. i update my database with the code i wrote > 2. those changes are reflected in the command line > 3. those changes are not reflected in Lita/SEP > > 1. I update information in Lita/SEP on that same database file > 2. those changes are reflected in Lita/SEP > 3. those changes are not reflected in the command line > > > This seems so bizarre to me. How can two different programs make > changes to one database file and the information i see is different in > these two programs, but correct according to the changes i made using > that program. > > > I appreciate any help. > Felipe > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
