> > 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 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.6/708 - Release Date: 3/2/2007 4:19 PM _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
