BobyIsProgress
Member
Hi everyone,
While doing some dynamic query I get the following error message while performing the query-prepare at runtime :
'QUERY-PREPARE' need to have one 'FOR EACH/PRESELECT' for each buffer memory of the query
This is my code:
While doing some dynamic query I get the following error message while performing the query-prepare at runtime :
'QUERY-PREPARE' need to have one 'FOR EACH/PRESELECT' for each buffer memory of the query
This is my code:
Code:
dispQuery:SET-BUFFERS(BUFFER FGSERV:HANDLE,BUFFER SACDPE:HANDLE,BUFFER SDTFOE:HANDLE,BUFFER VAFDAI:HANDLE,BUFFER VFGDAI:HANDLE) .
dispQuery:QUERY-PREPARE("FOR EACH FGSERV WHERE FGSERV.fgsign = 'user' NO-LOCK," +
"EACH SACDPE WHERE SACDPE.stecod = '" + c-stecod + "' " +
" AND SACDPE.dpeutidem MATCHES '" + fiUtidem + "' " +
(IF fiDatdeb <> ? THEN "AND SACDPE.dpedatdem >= " + STRING(fiDatdeb) + " " ELSE "") +
(IF fiDatfin <> ? THEN "AND SACDPE.dpedatdem <= " + STRING(fiDatfin) + " " ELSE "") +
" AND SACDPE.foucod MATCHES '" + fiFoucod + "' NO-LOCK," +
"EACH SDTFOE WHERE SDTFOE.foucod = SACDPE.foucod NO-LOCK," +
"EACH VAFDAI OUTER-JOIN WHERE VAFDAI.danum = SACDPE.acddemnum NO-LOCK" ) .