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.
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 /*field name qty data type is deci-10.*/ . end. end. for each tt_table : disp tt_week1. end.