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 <tim.romano...@gmail.com> wrote: > 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/2365982#2365982 > > Tim Romano > _______________________________________________ > 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