>>>>> "Phillip" == Phillip Grant <pgrant@stripped> writes:
Phillip> Hello All,
Phillip> I'm having a weird problem running an app that generates an SQL INSERT
Phillip> string and then executes it against a MySQL database. Goes something like
Phillip> this:
Phillip> lcString = "INSERT INTO tablename VALUES ( 'abc', 123, 'Here is the problem
Phillip> \?', 456, 'xyz' )"
Phillip> x = SQLEXEC( lnConnectionNum, lcString, "TmpCursor" )
Phillip> The code is superfluous, and it doesn't matter if you don't understand VFP
Phillip> syntax. The key is the "?". Even though I escape the question mark with
Phillip> the "\" as I'm supposed to, It is still getting treated as a view parameter.
Phillip> The ODBC driver reports back to VFP that it needs input, and VFP dutifully
Phillip> puts up a dialog asking the user:
Phillip> "Please input a value for: ', 456, 'xyz' )"
Phillip> Any ideas? I am also experiencing other 'escape' character problems,
Phillip> although I am following the MySQL/MyODBC documentation to the letter. Any
Phillip> and all help is greatly appreciated.
Phillip> Phillip Grant
Phillip> Grant Computer Consulting
Phillip> pgrant@stripped
Hi!
Any change that you can mail me a MyODBC trace file that shows this?
Regards,
Monty
