i have a view named spv_clientes with the following structure:
RUTA NUMBER (4, 0)
NUMCTE NUMBER (10, 0)
NOMBRE VARCHAR2 (60)
DIRECCION VARCHAR2 (36)
COLONIA VARCHAR2 (50)
CIUDAD VARCHAR2 (50)
CONTACTO VARCHAR2 (60)
TELEFONO VARCHAR2 (30)
VISITA NUMBER (22)
LISTA NUMBER (22)
CODIGOBARRAS NUMBER (6, 0)
RAZONNOATENDIDO CHAR (2)
RFC VARCHAR2 (15)
DIASATENCION VARCHAR2 (7)
CP VARCHAR2 (10)
when i run this query:
Select * from spv_clientes where ruta=301 and visita >0
on sqlplus i get 53 rows
and in corelab component i get 80 rows,
the field vista is filled with a decode statement.
im using version 3.01.5.0 with vb .net 2003 and pocketpc.