TMyDump->BackupQuery() line returns in commands

[ashlar64]

Hello,

I am using TMyDump->BackupQuery(). It is doing almost what I need it to do. The only problem is it is placing line returns \r\n within individual SQL commands. Placing them at the end of a command is fine (and something I want)...but when those characters are placed inside a SQL command it causes havoc. It would be very difficult to remove those since one of the fields is a text field and the text can contain many line returns.

So is there a way to turn off putting these characters inside a command string?

---Dave

[ashlar64]

I noticed if I do this command....

MyDump1->BackupQuery("SELECT * FROM _Utility_Versions WHERE Utility_Version_ID = 7");

It should only make 1 insert command....basically for record that equals 7? Is this correct? Because this table has 10 entries and it makes 10 insert commands in the string it passes back as of the WHERE cause is totally ignored.

[ashlar64]

ugh disregard my second message....I erred.

[Antaeus]

Try to set UseExtSyntax option to False. This will help to prevent dividing INSERT statements by several lines.