Query with a field calculated

[Elite237]

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:

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

 

[kenny.willems]

Hi Elite237,

I suppose you want to use the paramets in a query in the window polizas_contables.w.

If so, you need to work with dynamic queries. For example

DEFINE VARIABLE hQueryHandle AS HANDLE NO-UNDO.
ASSIGN hQueryHandle = BROWSE brwBrowse:QUERY.
hQueryHandle:QUERY-CLOSE().
hQueryHandle:QUERY-PREPARE("FOR EACH ttbrwBrowse NO-LOCK " +
" WHERE ttbrwBrowse.field1 = " + QUOTER(ipParameter1) +
" AND ttbrwBrowse.field2 = '" + STRING(ipParameter2) + "'").
hQueryHandle:QUERY-OPEN().

just add all your parameters in the query. use quoter for character parameters and string for numeric.

hope this helps