Dos Listbox filtrados dentro de un dialog
Publicado por David (40 intervenciones) el 16/12/2008 23:27:46
Hola, quisiera poner dentro de un DIALOG dos Folder con un listbox en cada uno, cada listbox filtra datos desde una misma base de datos, pero no me funciona. Alguien me puede ayudar. Gracias.
DEFINE DIALOG Ver FROM 3,4 TO 40,170 TITLE OemToAnsi("SITUACION ACTUAL DE LOS VEHICULOS") COLOR "R+/W"
@ 0,0 FOLDER oFolder PROMPT "DISPONIBLES", "ALQUILADOS" OF VER SIZE 660,250 // COLUMNA,FILA
SELECT VEHICULO
SET ORDER TO 3
SET FILTER TO VEHICULO->VNUMCARGOS = vnNum
VEHICULO->(dbGoTop())
@ 1, 1 LISTBOX oLbx1 ;
FIELDS OemToAnsi(VEHICULO->VMATRICULA),;
OemToAnsi(VEHICULO->VVEHICULO),;
OemToAnsi(VEHICULO->VRENTING),;
OemToAnsi(VEHICULO->VPROPIEDAD),;
OemToAnsi(DTOC(VEHICULO->VFEALQ)),;
OemToAnsi(VEHICULO->VCONDUC),;
OemToAnsi(VEHICULO->VCARGO1),;
OemToAnsi(VEHICULO->VCARGO2),;
OemToAnsi(VEHICULO->VCARGO3),;
OemToAnsi(VEHICULO->VCARGO4),;
OemToAnsi(VEHICULO->VCARGO5),;
OemToAnsi(VEHICULO->VCARGO6),;
OemToAnsi(STR(VEHICULO->VBENEFICIO));
HEADERS "MATRICULA", "VEHICULO", "R", "P", "FE-ALQ" , "CONDUCTOR", "CARGO-1", "CARGO-2", "CARGO-3", "CARGO-4", "CARGO-5", "CARGO-6", "BENEFICIO";
FIELDSIZES 80, 100, 15, 15, 70, 150, 150, 150, 150, 150, 150, 150, 100;
SELECT VEHICULO->VNUMCARGOS FOR vnNum TO vnNum;
ON LEFT DBLCLICK (SW0:=.T., MOSTRARVEHI(oLbx,SW0,SW1));
SIZE 638, 165; // Tama¤o del TBrowse
OF oFolder:aDialogs[2]
SELECT VEHICULO
SET ORDER TO 4
SET FILTER TO VEHICULO->VCONDUC = vcConduc
VEHICULO->(dbGoTop())
@ 1, 1 LISTBOX oLbx ;
FIELDS OemToAnsi(VEHICULO->VMATRICULA),;
OemToAnsi(VEHICULO->VVEHICULO),;
OemToAnsi(VEHICULO->VRENTING),;
OemToAnsi(VEHICULO->VPROPIEDAD),;
OemToAnsi(DTOC(VEHICULO->VFEALQ)),;
OemToAnsi(VEHICULO->VCONDUC),;
OemToAnsi(VEHICULO->VCARGO1),;
OemToAnsi(VEHICULO->VCARGO2),;
OemToAnsi(VEHICULO->VCARGO3),;
OemToAnsi(VEHICULO->VCARGO4),;
OemToAnsi(VEHICULO->VCARGO5),;
OemToAnsi(VEHICULO->VCARGO6),;
OemToAnsi(STR(VEHICULO->VBENEFICIO));
HEADERS "MATRICULA", "VEHICULO", "R", "P", "FE-ALQ" , "CONDUCTOR", "CARGO-1", "CARGO-2", "CARGO-3", "CARGO-4", "CARGO-5", "CARGO-6", "BENEFICIO";
FIELDSIZES 80, 100, 15, 15, 70, 150, 150, 150, 150, 150, 150, 150, 100;
SELECT VEHICULO->VCONDUC FOR vcConduc TO vcConduc;
ON LEFT DBLCLICK (SW0:=.T., MOSTRARVEHI(oLbx,SW0,SW1));
SIZE 638, 165; // Tama¤o del TBrowse
OF oFolder:aDialogs[1]
@ 14.4,02 BUTTON "Aceptar" OF Ver;
ACTION (Ver:END())
@ 14.4,13 BUTTON "Cancelar" OF Ver;
ACTION (SW := .T., Ver:End());
CANCEL
@18.5,24 ICON oIco1 OF Ver;
FILENAME "C:SOTECVEUTILValid.ICO"
oLbx:Refresh()
oLbx1:Refresh()
ACTIVATE DIALOG VER CENTER;
DEFINE DIALOG Ver FROM 3,4 TO 40,170 TITLE OemToAnsi("SITUACION ACTUAL DE LOS VEHICULOS") COLOR "R+/W"
@ 0,0 FOLDER oFolder PROMPT "DISPONIBLES", "ALQUILADOS" OF VER SIZE 660,250 // COLUMNA,FILA
SELECT VEHICULO
SET ORDER TO 3
SET FILTER TO VEHICULO->VNUMCARGOS = vnNum
VEHICULO->(dbGoTop())
@ 1, 1 LISTBOX oLbx1 ;
FIELDS OemToAnsi(VEHICULO->VMATRICULA),;
OemToAnsi(VEHICULO->VVEHICULO),;
OemToAnsi(VEHICULO->VRENTING),;
OemToAnsi(VEHICULO->VPROPIEDAD),;
OemToAnsi(DTOC(VEHICULO->VFEALQ)),;
OemToAnsi(VEHICULO->VCONDUC),;
OemToAnsi(VEHICULO->VCARGO1),;
OemToAnsi(VEHICULO->VCARGO2),;
OemToAnsi(VEHICULO->VCARGO3),;
OemToAnsi(VEHICULO->VCARGO4),;
OemToAnsi(VEHICULO->VCARGO5),;
OemToAnsi(VEHICULO->VCARGO6),;
OemToAnsi(STR(VEHICULO->VBENEFICIO));
HEADERS "MATRICULA", "VEHICULO", "R", "P", "FE-ALQ" , "CONDUCTOR", "CARGO-1", "CARGO-2", "CARGO-3", "CARGO-4", "CARGO-5", "CARGO-6", "BENEFICIO";
FIELDSIZES 80, 100, 15, 15, 70, 150, 150, 150, 150, 150, 150, 150, 100;
SELECT VEHICULO->VNUMCARGOS FOR vnNum TO vnNum;
ON LEFT DBLCLICK (SW0:=.T., MOSTRARVEHI(oLbx,SW0,SW1));
SIZE 638, 165; // Tama¤o del TBrowse
OF oFolder:aDialogs[2]
SELECT VEHICULO
SET ORDER TO 4
SET FILTER TO VEHICULO->VCONDUC = vcConduc
VEHICULO->(dbGoTop())
@ 1, 1 LISTBOX oLbx ;
FIELDS OemToAnsi(VEHICULO->VMATRICULA),;
OemToAnsi(VEHICULO->VVEHICULO),;
OemToAnsi(VEHICULO->VRENTING),;
OemToAnsi(VEHICULO->VPROPIEDAD),;
OemToAnsi(DTOC(VEHICULO->VFEALQ)),;
OemToAnsi(VEHICULO->VCONDUC),;
OemToAnsi(VEHICULO->VCARGO1),;
OemToAnsi(VEHICULO->VCARGO2),;
OemToAnsi(VEHICULO->VCARGO3),;
OemToAnsi(VEHICULO->VCARGO4),;
OemToAnsi(VEHICULO->VCARGO5),;
OemToAnsi(VEHICULO->VCARGO6),;
OemToAnsi(STR(VEHICULO->VBENEFICIO));
HEADERS "MATRICULA", "VEHICULO", "R", "P", "FE-ALQ" , "CONDUCTOR", "CARGO-1", "CARGO-2", "CARGO-3", "CARGO-4", "CARGO-5", "CARGO-6", "BENEFICIO";
FIELDSIZES 80, 100, 15, 15, 70, 150, 150, 150, 150, 150, 150, 150, 100;
SELECT VEHICULO->VCONDUC FOR vcConduc TO vcConduc;
ON LEFT DBLCLICK (SW0:=.T., MOSTRARVEHI(oLbx,SW0,SW1));
SIZE 638, 165; // Tama¤o del TBrowse
OF oFolder:aDialogs[1]
@ 14.4,02 BUTTON "Aceptar" OF Ver;
ACTION (Ver:END())
@ 14.4,13 BUTTON "Cancelar" OF Ver;
ACTION (SW := .T., Ver:End());
CANCEL
@18.5,24 ICON oIco1 OF Ver;
FILENAME "C:SOTECVEUTILValid.ICO"
oLbx:Refresh()
oLbx1:Refresh()
ACTIVATE DIALOG VER CENTER;
Valora esta pregunta


0