On Saturday 03 March 2007 10:23, Ken Dibble wrote: > > > Okay, this is an artifact of the kind of jumpy "intellisense" in > > > the Class > > > Designer. > > > > Yeah, I don't like that behavior either. If you don't have a > > match, it shouldn't put anything in at all, but I can't find a way to fix > > that. > > After dealing with that, correcting my bad MySQL CASE syntax, and realizing > how to use the \ line-continuation character in Dabo (same as ";" in VFP), > I'm left with the following error: > > --------------------------- > Database Action Failed > --------------------------- > (1064, "You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use near > '== musPerfs.artid JOIN musBands ON musBands.pkid == musPerfs.artid WHERE > musPerf' at line 1") > SQL: SELECT musSongs.song, (SELECT CASE musPerfs.arttype WHEN "P" THEN > musPeople.lastname WHEN "B" THEN musBands.bandname ELSE " " END FROM > musPerfs JOIN musPeople ON musPeople.pkid == musPerfs.artid JOIN musBands > ON musBands.pkid == musPerfs.artid WHERE musPerfs.songid == musSongs.pkid) > AS artist FROM musSongs JOIN musPerfs ON musPerfs.songid == musSongs.pkid > JOIN musRecs ON musRecs.perfid == musPerfs.pkid > > I assume I've made another MySQL error, because this query (in VFP syntax) > works in VFP. So this is OT for this list, but can you make a suggestion > anyway? > > Thanks. > > Ken Does MySQL accept "==" vs "=". -- John Fabiani
_______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
