I have 2 views of the same Oracle table. One returns to me every records; another one ask user a code to return only one record.
The first view returns correctly every records in oracle's table.
Well, second view only returns the record if the code is 15 characters length. Otherwise view remains empty.
The field in table and in views is c(20)
I've tested with the two oracle's ODBC drivers: Microsoft's one and Oracle's one.
Any ideas?
TIA