view problem

view problem

Postby rene » Thu 16 Feb 2006 19:14

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.
rene
 
Posts: 2
Joined: Thu 16 Feb 2006 18:44

Postby rene » Thu 16 Feb 2006 20:01

im sorry i solved my problem it was a problem with the session
i just change som session variables and that was all.
rene
 
Posts: 2
Joined: Thu 16 Feb 2006 18:44

Postby Alexey » Wed 13 Dec 2006 16:27

OK.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle