no case sensitive problem. I've tested both upper and lower options.
This is the view doesnt works:
CREATE SQL VIEW "PRODUCTO" ;
REMOTE CONNECT "OracleDanosa" ;
AS SELECT * FROM SIGES.tartigen Tartigen ;
WHERE Tartigen.CDARTGEN = ?m.codigo
m.codigo = "D0001234"
requery("producto") && returns no records found
This is the view that works fine:
CREATE SQL VIEW "PRODUCTO" ;
REMOTE CONNECT "OracleDanosa" ;
AS SELECT * FROM SIGES.tartigen Tartigen ;
WHERE Tartigen.CDARTGEN >= ?m.desde ;
and Tartigen.CDARTGEN <= ?m.hasta
m.desde = "D0001234"
m.hasta = "D00012340"
requery("producto") && returns 1 ok record
>Case sensitive problem? COuld you post your query along with some sample data?
>
>>I've tested with padr and no results too.
>>I've tested with other Oracle tables and everything works fine. It's only this one.
>>More ideas?
>>
>>>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
Saludos,
A.G.P.
---------