It is now bug 10940 http://quality.runrev.com/show_bug.cgi?id=10940.
I've confirmed in 6.0.1 commercial, and a 6.0.1 standalone, as well. I've also seen that SQLite returns incorrect results. put "BEGIN TRANSACTION;" & cr into dcmd > put "SELECT '1', * FROM testtable WHERE ky='cat';" & cr after dcmd > put "SELECT '2', dat FROM testtable WHERE ky='chicken';" & cr after dcmd > put "SELECT '3', ky FROM testtable ;" & cr after dcmd > put "SELECT '4', ky, ky FROM testtable WHERE ky='chicken' ;" & cr after > dcmd > put "SELECT '5', ky FROM testtable WHERE ky='cat';" & cr after dcmd > > put "COMMIT" & cr after dcmd > when I switch from 2 to 1 fields, the result for the last field of the last line of the prior query continues to report: 1 cat a lazy animal 2 a tasty bird a lazy animal 3 cat a lazy animal 3 chicken a lazy animal 4 chicken chicken 5 cat chicken *sigh* -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
