Re: Inserting records using Informix ODBC

#1 (**permalink**) 04-19-2008, 09:39 PM

--0__=09BBE4DEDFF3B4968f9e8a93df938690918c09BBE4DEDF F3B496
Content-type: multipart/alternative;
Boundary="1__=09BBE4DEDFF3B4968f9e8a93df938690918c 09BBE4DEDFF3B496"

--1__=09BBE4DEDFF3B4968f9e8a93df938690918c09BBE4DEDF F3B496
Content-type: text/plain; charset=US-ASCII

Can you provide more specifics about the query you are executing, the error
that you are getting back? Also let me know the ODBC or CSDK version you
are using?

I executed the following & didn't see any problems
drop table charTest;
create table charTest (charCol CHAR(30));
insert into charTest values('This code''s all wrong');
insert into charTest values("This code's all wrong");

Are you by any chance trying a literal insert into TEXT column? I
personally doubt that as you said you are migrating 4GL system to VB. And
afaik, 4GL doesn't have support for literal inserts into TEXT
columns. Just trying to narrow down the problem area.

Regards,
Kanchana Padmanabhan

Software Engineer
R&D - IBM Data Management Group
11200 Lakeview, Lenexa, KS 66219
Tel: 913 599 8674 t/l : 337 8674 Fax: 913 599 7260

|---------+---------------------------->
| | "me" |
| | <mark@cuskit.co.u|
| | k> |
| | Sent by: |
| | owner-informix-li|
| | st@iiug.org |
| | |
| | |
| | 03/04/2004 05:19 |
| | AM |
| | Please respond to|
| | "me" |
|---------+---------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
| |
| To: informix-list@iiug.org |
| cc: |
| Subject: Inserting records using Informix ODBC |
>------------------------------------------------------------------------------------------------------------------------------|

Hi all,

We are currently converting the old 4GL system using VB, connecting to
Informix SE using Informix ODBC.

Everything works fine apart from inserting/updating records that have
single
quotes in them

eg insert into table....blahh blahh "This code's all wrong" etc etc

The old Informix system seems to handle single quotes in strings just fine
but the ODBC drivers don't like them.

I can obviously search for the erroneous quote and replace it with
something
else and then do the reverse when i read it back, however that would mean
going through all the old Informix code and doing the same thing, something
I don't really want to do!

Anyone got any ideas, its obviously something to do with the ODBC but can't
see anything obvious in the settings etc

Thanks in advance

Mark Jerrom

--1__=09BBE4DEDFF3B4968f9e8a93df938690918c09BBE4DEDF F3B496
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline

<html><body>
Can you provide more specifics about the query you are executing, the error that you are getting back? Also let me know the ODBC or CSDK version you are using? 
 
I executed the following & didn't see any problems 
drop table charTest; 
create table charTest (charCol CHAR(30)); 
insert into charTest values('This code''s all wrong'); 
insert into charTest values("This code's all wrong&quot

; 
 
Are you by any chance trying a literal insert into TEXT column? I personally doubt that as you said you are migrating 4GL system to VB. And afaik, 4GL doesn't have support for literal inserts into TEXT 
columns. Just trying to narrow down the problem area. 
 
 
Regards, 
Kanchana Padmanabhan 
 
Software Engineer 
R&D - IBM Data Management Group 
11200 Lakeview, Lenexa, KS 66219 
Tel: 913 599 8674 t/l : 337 8674 Fax: 913 599 7260 
 
<img src="cid:10__=09BBE4DEDFF3B4968f9e8a93df938@us.ibm .com" width="16" height="16" alt="Inactive hide details for "me" <mark@cuskit.co.uk>">"me" <mark@cuskit.co.uk> 
 
 

<table V5DOTBL=true width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="1%"><img src="cid:20__=09BBE4DEDFF3B4968f9e8a93df938@us.ibm .com" border="0" height="1" width="72" alt=""> 
</td><td style="background-image:url(cid:30__=09BBE4DEDFF3B4968f9e8a93df938@u s.ibm.com); background-repeat: no-repeat; " width="1%"><img src="cid:20__=09BBE4DEDFF3B4968f9e8a93df938@us.ibm .com" border="0" height="1" width="225" alt=""> 

<ul>
<ul>
<ul>
<ul>"me" <mark@cuskit.co.uk> 
Sent by: owner-informix-list@iiug.org
03/04/2004 05:19 AM 
Please respond to "me"</ul>
</ul>
</ul>
</ul>
</td><td width="100%"><img src="cid:20__=09BBE4DEDFF3B4968f9e8a93df938@us.ibm .com" border="0" height="1" width="1" alt=""> 
 
 To: informix-list@iiug.org 
 cc: 
 Subject: Inserting records using Informix ODBC</td></tr>
</table>
 
 
<tt>Hi all, 
 
We are currently converting the old 4GL system using VB, connecting to 
Informix SE using Informix ODBC. 
 
Everything works fine apart from inserting/updating records that have single 
quotes in them 
 
eg insert into table....blahh blahh "This code's all wrong" etc etc 
 
The old Informix system seems to handle single quotes in strings just fine 
but the ODBC drivers don't like them. 
 
I can obviously search for the erroneous quote and replace it with something 
else and then do the reverse when i read it back, however that would mean 
going through all the old Informix code and doing the same thing, something 
I don't really want to do! 
 
Anyone got any ideas, its obviously something to do with the ODBC but can't 
see anything obvious in the settings etc 
 
Thanks in advance 
 
Mark Jerrom 
 
 
</tt>

</body></html>

--1__=09BBE4DEDFF3B4968f9e8a93df938690918c09BBE4DEDF F3B496--

--0__=09BBE4DEDFF3B4968f9e8a93df938690918c09BBE4DEDF F3B496
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=09BBE4DEDFF3B4968f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYX J0U2F2ZXIhAAA7

--0__=09BBE4DEDFF3B4968f9e8a93df938690918c09BBE4DEDF F3B496
Content-type: image/gif;
name="ecblank.gif"
Content-Disposition: inline; filename="ecblank.gif"
Content-ID: <20__=09BBE4DEDFF3B4968f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7

--0__=09BBE4DEDFF3B4968f9e8a93df938690918c09BBE4DEDF F3B496
Content-type: image/gif;
name="pic31564.gif"
Content-Disposition: inline; filename="pic31564.gif"
Content-ID: <30__=09BBE4DEDFF3B4968f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA
AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh
EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZe ZgLVA9YVCpnGagVjV171aRVrYR
RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFil KQdI8GA5IcpApeJQt8L09lmgkH
LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d 5VyKtCKW3jfz4uMKmq3xu4N0nK
BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI
TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZl qWmyFy5/6yBBuji0AxFR
M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNU tJOUAVLoUr1+wqDGTE4zk+T6FG
uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO 3mpOaKnL0Z2EKvNMSILEThKhCg
zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXp uFKhSYZALd0O5RKa2z9EYKBbpb
qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NE NQj2jXjmfNgOZDaXb5glRmXQ33
YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4 rwxxINMvpFFAz1KOODHiu+4aEw
NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoC WOOUwgltIwAKRxJgbIkJAQZEq0
2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ 6ChjCAH3QlhJcT6VWE6FCkfCco
CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3 QxhgohNKXJCWv8JQr/PDdaqd6w
2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iIm THEQyqJ4eIxJJoUBc+3CbBuwZE
V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKquXF6k4senwEhYG nKEFJeGrxUZy8dB8gmAXI/sPvH
ESfCwVt5hTgYiqQqtdRNHQIU1PJ33ZqmzgE90OwLaoJcnMop1W iMmgkPHQRIrwgFuNV90A3doNKT
mrKIN07AnGcI9BQjhCBN4RfA1qIZnMqorJCogKfGQnxSCDilTV IA0yl5ciTovgLuBDKFUDE9aQcw
9SA+rjSNf9/M1gxrj6VwDTS0IUSElMzBfsj0NFXR2kwsV1A5IF1grLgLL/r1R40BZEnuBWgmQEyb
jqRwSAt6bqMCOFkvKFN2GPPkUzIm/SCF8z8pVzpbjVnMsy0vOr1hw3SaSRUhpY09v0z0J1FnwzPl
fmh+xl4WtR0zGu24I4KbMQm3lnVu2oNWxI9W/lcyzA+mCKF4DBikxb/+UWtOGRiFP8qEwAayIgIA
Ow==

--0__=09BBE4DEDFF3B4968f9e8a93df938690918c09BBE4DEDF F3B496--

sending to informix-list

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode