Just ran into a serious problem with and SQLite SELECT statement in 4.5.

I'm selecting data from my database with the following SQLite statement

put revDataFromQuery(,,gDBID,myLine) after tdata

myline contains SELECT PlaceID, Name || ',' || City || ',' || State AS Location FROM Places ORDER BY Name

In 4.0, this successfully selects all the correct data. In 4.5 is selects only 2 rows. Same codebase, same database. Executing the SELECT in 2 or 3 different SQLite query utilities returns the correct data

Has anyone run into this type of issue with 4.5?

Pete Haworth








_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to