[progress Communities] [progress Openedge Abl] Forum Post: Dynamic Query

  • Thread starter Thread starter Ab Himmit
  • Start date Start date
Status
Not open for further replies.
A

Ab Himmit

Guest
Hello All, I'm try to build query buffers from a list. Please see below code V6.11; If I use the commented out line, the query works fine. If I use the ADD-BUFFER method, the query does not work. DEFINE VARIABLE lv_Buffers AS HANDLE NO-UNDO. DEFINE VARIABLE retrn AS LOGICAL NO-UNDO. CREATE QUERY qry_Address. DO lv_x = 1 TO NUM-ENTRIES (ip_Buffers): // MESSAGE ENTRY(lv_x, ip_Buffers) VIEW-AS ALERT-BOX. CREATE BUFFER lv_buffers FOR TABLE ENTRY(lv_x, ip_Buffers). qry_Address:ADD-BUFFER(lv_Buffers:HANDLE). END. // qry_Address:SET-BUFFERS(BUFFER addrtype:HANDle , BUFFER address:HANDLE). qry_Address:QUERY-PREPARE (ip_QueryString ). retrn = qry_Address:QUERY-OPEN (). IF NOT retrn THEN DO: MESSAGE "No records founds" VIEW-AS ALERT-BOX. RETURN. END. Thanks for your help.

Continue reading...
 
Status
Not open for further replies.
Back
Top