You could also try doubling up the embedded delimiter like this when building your SQL statement:
[select Lname from customer where Fname like 'O''Mally'] I know this will work with VFP and MSSQL ODBC but don't know about the MYSQL ODBC connector. It's also possible there's some flag in the MYSQL ODBC connector that tells it how to deal with delimiters. I've got a MYSQL setup hanging around her somewhere. I'll try it out if I have a moment... -- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Mike Copeland Subject: Re: SQL statement formation That's what I was afraid of... So, is it an option to escape the ' and " with \? Like this: [select Lname from customer where Fname like 'O\'Mally'] Mike -------- Original Message -------- Subject: Re: SQL statement formation From: Tracy Pearson <[email protected]> > Mike, > > You can use the [] on the outside and the " on the inside instead of the '. > You may still run into the variable having a " in it though. > > Tracy Pearson > PowerChurch Software _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD0442188F510C9@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
