Devart Forums

I have the following lines in my (very long) script file:
TMyScript translates the &destschema to "myschemaname" with double quotes. The trouble is that I think it should use a special single quote like so: `myschemaname`.

If I manually execute the script with (`) quotes using the MySQL query browser, it works. If I use double quotes (") in a manual query it fails with a syntax error.

The TMyScript is failing with syntax errors, so I think the problem is the quotes. Any ideas?

Best regards,

Kevin G. McCoy

Hello,

This is a correct behaviour. If you set the macro value using the AsString property, its value is set to ''value'' (it's not a double quotes) that means that it stores the string 'value'. To avoid this problem, you should use the following code:

Perfect, and thank you for the quick response!

Kevin

Feel free to contact us if you have any other questions about MyDAC.