pervasiveSQL / betrieve .. is the db i have to use. and you have a good point about the sql. i will keep digging around to see what i can do
On Sep 18, 7:24 pm, Jeremy Evans <[email protected]> wrote: > On Sep 18, 5:41 pm, daniel_spaniel <[email protected]> wrote: > > > One more thing, I tested on mysql and it was fine, but the other db i > > am using does not like the sql like: > > > SELECT * FROM "TRIP PASSENGERS" > > WHERE (("KID - DATE", "KID - TIME", "KID - USER", "KID - MULT", "KID > > - COMM")) IN ((39350,764,4,0,17),(39829,10,20,3,4)) > > Which database doesn't like that? > > > it prefers > > > SELECT * FROM "TRIP PASSENGERS" > > WHERE "KID - DATE" IN (39350,39829) and > > "KID - TIME" IN (764,10) and > > "KID - USER" IN (4,20) and > > "KID - MULT" IN (0,3) and > > "KID - COMM" IN (17,4) > > > is there a way to switch to that style somehow? > > That style is incorrect (it selects rows that don't match), so no. > > Jeremy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
