If the view was populated with data via VFP and the Oracle column is of type VarChar2, you will have to either right pad your value with spaces to match the field width or trim the field name.

cValue = padr(cValue, 20, " ")
WHERE myfield = ?cValue



>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