[Stackoverflow] [Progress OpenEdge ABL] Getting Error - Phrase or option conflicts with previous phrase or option. (277) - Progress 4GL

Thiru

Guest

Apr 28, 2022

I am using following dynamic query to fetch the data from a table. But I am getting compilation error "Phrase or option conflicts with previous phrase or option. (277)". Not sure where I am making mistakes and how to fix it. Please help me modifying the below example query.

Code:

define variable hbuffer as handle    no-undo.
define variable hQuery  as handle    no-undo.
define variable cQuery  as character no-undo.

define temp-table tt_table no-undo           
field tt_data    as character label "Week1"
.

create buffer hbuffer for table "<table>".
cQuery = "for each <table> no-lock ".
create query hQuery.
hQuery:set-buffers(hbuffer).
cQuery = cQuery + ":".
hQuery:query-prepare(cQuery).
hQuery:query-open().
if hQuery:query-open() then
do:
   do while hQuery:get-next():
      create tt_table.
      assign tt_week1 = hbuffer::qty[1] /*field name qty data type is deci-10[52].*/
      .
   end.
end.

for each tt_table :
   disp tt_week1.
end.