Search found 19 matches

by joycekai
01.02.2013, 16:41
Forum: ZeosLib 7.0 Stable Forum
Topic: [patch_done] single quotes in queries
Replies: 30
Views: 5098

When I said Michael's reply was not clear, I mostly meant that he did not provide an example of using the function, or even the correct name of the function. His English is fine, and I really appreciate that you are both paying attention to this problem. I am in the U.S., and I just checked and made...
by joycekai
31.01.2013, 14:59
Forum: ZeosLib 7.0 Stable Forum
Topic: [patch_done] single quotes in queries
Replies: 30
Views: 5098

The problem occurs in both text and varchar fields. Your answer is not at all clear. I could not find an "EscapeString" function on the connection object. I did find GetAnsiEscapeString and GetBinaryEscapeStringFromString. I tried both of those in the example by changing one statement zq.F...
by joycekai
30.01.2013, 23:10
Forum: ZeosLib 7.0 Stable Forum
Topic: [patch_done] single quotes in queries
Replies: 30
Views: 5098

OK, I did a simple program like you asked, and got the same error. I had 2 buttons -- one that used components (that was mostly to get the right things in the uses clause) and one that did it completely in code. Both ways got the same result. I had manually added one record to the equipment table so...
by joycekai
30.01.2013, 20:55
Forum: ZeosLib 7.0 Stable Forum
Topic: [patch_done] single quotes in queries
Replies: 30
Views: 5098

[patch_done] single quotes in queries

I just updated to Delphi 2010 from Delphi 2006. At the same time, I upgraded from Zeos 6.6.2 to 7.0.3. Previously, when I tried to post data that contained a single quote, it posted just fine. Now it does not work. I get an SQL error. The attachment shows the Delphi call stack for 2 different ways t...