[Progress Communities] [Progress OpenEdge ABL] Forum Post: Using a find first query on a browse buffer handle does not show all fields

  • Thread starter Thread starter nix1016
  • Start date Start date
Status
Not open for further replies.
N

nix1016

Guest
I'm having some issues where if I run a query based on a buffer-field obtained from a browse query, not all fields are available. For example, if I run the below code, I will get a blank customer.custName but buffer:buffer-field("custName"):buffer-value shows the correct value. It doesn't seem to be happening on all fields and I'm not sure what the correlation is between the fields that show and those that don't; fields that are displayed in the browse are also affected. Any ideas? create buffer hbuffer for table "customer". hbuffer = browse {&browse-name}:query:get-buffer-handle(1). browse {&browse-name}:query:get-first(). repeat i=1 to browse {&browse-name}:query:num-results. if valid-handle(hbuffer) then do. find first customer where customer.custNum = hbuffer:buffer-field("custNum"):buffer-value no-lock no-error. if available customer then do. message customer.custName hbuffer:buffer-field("custName"):buffer-value. end. end. browse {&browse-name}:query:get-next(). end.

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