Doubt about the correction for 0000048
Posted: 13.09.2007, 18:28
I could not update for test the correction myself, yet.
I am using the TZSQLProcessor with ParamCheck False and default delimiter options.
What if I have a statement with the delimiter ";" inside a string?
For example:
1. insert into TABLE (FIELD) values ('aaa;aaa');
2. insert into TABLE (FIELD) values ('aa"aa;a"aa');
At least for example number 2 the statement is ignored.
Will the correction for 0000048 solve this kind of problem?
Or should I use a ;#13#10 as delimiter to workaround it?
I am using the TZSQLProcessor with ParamCheck False and default delimiter options.
What if I have a statement with the delimiter ";" inside a string?
For example:
1. insert into TABLE (FIELD) values ('aaa;aaa');
2. insert into TABLE (FIELD) values ('aa"aa;a"aa');
At least for example number 2 the statement is ignored.
Will the correction for 0000048 solve this kind of problem?
Or should I use a ;#13#10 as delimiter to workaround it?