Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 11 to 13 of 13 total |
Escaping a quote in an INSERT |
Fri, Sep 11 2009 12:34 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Malcolm,
<< I can get it to prepare OK in the manager (UNICODE in case it matters) But when run it reports: "The execution of the script did not complete and was stopped at 0 seconds". >> Did you get an actual error message at all ? << Here is a script to build the actual table as well as the INSERT statement that fails. You will note that the AsciiName is using #96 instead of #39 .. just to avoid any confusion while debugging. (I hope I don't get into trouble for posting it here instead of the binaries). >> Nah, text stuff is fine here. The script works fine here with EDB 2.02 B15. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Sep 11 2009 2:53 PM | Permanent Link |
"Malcolm" | Hi Tim and Uli
Thanks for the confirmation that it works for you. That is a relief and what I expected - must be something wrong at this end. I will work it out soon .. I hope! Malcolm |
Fri, Sep 11 2009 3:42 PM | Permanent Link |
"Malcolm" | Well, I'll be hornswaggled!
Now it works .. and I didn't change a thing! I hate it when I don't understand what happened <grrrr> But I like it when it works. OK, what's next ... |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |