Use parameters?

ds.sql.add('insert into stkmaster ( stkid_vc, stkdesc_vc ) values (:id,:vc)');

ds.parambyname('id').asString := 'HH`';
ds.parambyname('vc').asString := 'HH Desc';

ds.execsql;

Or something like that.

-----Original Message-----
From: HH Tan [mailto:hhtan@...]
Sent: Tuesday, 24 February 2004 3:57 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Double quote & ` in insert statement


How to store " & ` character in insert statement.

I had 2 insert statements as follow :

insert into stkmaster ( stkid_vc, stkdesc_vc ) values ('HH"','HH
Desc') ;

insert into stkmaster ( stkid_vc, stkdesc_vc ) values ('HH`','HH
Desc') ;


When execute using Tquery, it generate exception (Xsqlda index out of
range).

I am using Delphi 5, IBX and Firebird R4 running on Win XP pro.


Any help will appreciated.

Thank you


Yahoo! Groups Sponsor
ADVERTISEMENT






Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.