HI, I NEED TO KNOW HOW I CAN DO A QUERY WITH A FIELD CALCULATED.
I HAVE MY BROWSE, AND I DID A FIELD CALCULATED, AND I HAVE OTHER WINDOW, I´AM TRY DO A QUERY FOR CAN OPEN THE OTHER WINDOW ACCORDING WITH THE VALUES OF THE BROWSE. MY CODE IS:
WITH THIS CODE, IF APPLICA, OPEN A WINDOW WITH A BROWSE. ALSO I NEED TO PASS PARAMETERS THEN I DON´T KNOW IF IS OK PASS THE VALUES LIKE I DID IT. THANKS
I HAVE MY BROWSE, AND I DID A FIELD CALCULATED, AND I HAVE OTHER WINDOW, I´AM TRY DO A QUERY FOR CAN OPEN THE OTHER WINDOW ACCORDING WITH THE VALUES OF THE BROWSE. MY CODE IS:
Code:
ON CHOOSE OF BTN-PCONTABLE
DO:
FIND M_polizas WHERE M_polizas.cve_empresa = Reembolso.cve_empresa
AND M_polizas.cve_zona = Reembolso.cve_zona
AND M_polizas.poliza = STRING (Reembolso.chequera,">>9") + "0" + STRING (Reembolso.cheque,">>>>>>9")
AND M_poliza.fecha = Reembolso.fecha NO-ERROR.
IF AVAILABLE M_polizas THEN
RUN Polizas_Contables.w(Reembolso.cve_empresa, Reembolso.cve_zona,
STRING (Reembolso.chequera,">>9") + "0" + STRING (Reembolso.cheque,">>>>>>9"), Reembolso.fecha).
ELSE
MESSAGE "No se encontraron polizas contables" VIEW-AS ALERT-BOX WARNING.
END.
WITH THIS CODE, IF APPLICA, OPEN A WINDOW WITH A BROWSE. ALSO I NEED TO PASS PARAMETERS THEN I DON´T KNOW IF IS OK PASS THE VALUES LIKE I DID IT. THANKS