Moving from D2006 to XE2 and TMyScript.SQL

davidmarcus · Post by **davidmarcus** » Thu 22 Dec 2011 19:38

I'm updating my apps from Delphi 2006 to Delphi XE2. I've been using TMyScript by constructing the SQL myself, assigning it to TMyScript.SQL.Text, then doing TMyScript.Execute. I escape and quote the values myself, i.e., put single quotes around strings, prefix quotes with a backslash, etc. I end up with a string (UnicodeString in XE2) that I assign to TMyScript.SQL.Text. I have TMyConnection.Options.CharSet set to 'latin1'. The tables all use latin1 as the character set.

Will this still work with Delphi XE2?

I'm using MyDAC 7.1, Delphi XE2 Professional, Windows Vista Home Premium.

AndreyZ · Post by **AndreyZ** » Fri 23 Dec 2011 10:00

Hello,

Yes, it will work in Delphi XE2.

davidmarcus · Post by **davidmarcus** » Fri 23 Dec 2011 14:16

Thank you.