Data records with empty LVARCHAR fields are not returned(Correcti
Posted in 1999
Topics: Connectivity: ODBC / JDBC / .NET, Data Types & Schema Design
Hallo,
I have a problem with Informix ODBC driver 3.3 and Micrososft ADO 2.1
and VB6
Data records with empty LVARCHAR fields are not returned.
System configuration:
Winnt 4.0 Server SP4
Informix ODBC Driver 3.3.0.0000 2.30.TC1
Version 3.30.00.10139
Microsoft VisualBasic 6.0 with Ado 2.1
The error can be reproduced as follows:
Create a table:
create table AdoTest(f1 varchar, f2 lvarchar)One column of the table is of the data type LVARCHAR.
Add data records to the table:
insert into AdoTest(f1,f2)Values('a','aaa')
insert into AdoTest(f1,f2)Values('b','bbb')
insert into AdoTest(f1,f2)Values('c','ccc')
Read all records:
select * from AdoTest
Result is ok.
f1 f2
---------
a aaa
b bbb
c ccc
Insert a null string in the field LVACHAR f2.
update AdoTest Set f2='' where f1='b'
Read all records:
select * from AdoTest
Result is wrong.
f1 f2
--------
a aaa
The records from the 2nd record on are missing.
select * from AdoTest where f1='b' returns an error message. (No current
record available.)
If a character is inserted in the field f2, all records are readable
again.
update AdoTest Set f2='bbb' where f1='b'.
This problem does not occur with the driver Informix ODBC 2.80.0007.
This one has other problems.
Do you have a solution?
Regards
Nicolas