Re: [sqlite] Problem with sqlite providing different programs different data

2010-04-01 Thread Felipe Aramburu
Hey thanks for the advice after further testing I found this to be a windows file system issue. windows made a boo boo and had discrepancy between what could be accessed on the command line and what was shown in windows On Thu, Apr 1, 2010 at 3:11 PM, Tim Romano wrote: > I should add that when yo

Re: [sqlite] Problem with sqlite providing different programs different data

2010-04-01 Thread Tim Romano
I should add that when you create a SQLite database outside of Adobe and use INT PK, in Adobe's implementation joins will return perfectly plausible yet often completely inaccurate results, grabbing rows from the joined table with the RowID not the actual PK. http://forums.adobe.com/message/236598

Re: [sqlite] Problem with sqlite providing different programs different data

2010-04-01 Thread Tim Romano
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

Re: [sqlite] Problem with sqlite providing different programs different data

2010-04-01 Thread Jean-Christophe Deschamps
>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 co

[sqlite] Problem with sqlite providing different programs different data

2010-04-01 Thread Felipe Aramburu
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,@me