Cannot Get on query brConnections which is not opened.

[chat2004]

Hi all,

I'm new to Progress, and I have a problem when set dynamic query for browse. When set dynamic query for the browse, I get this error "Cannot Get on query brConnections which is not opened.".

My code:

define variable hQuery           as WIDGET-HANDLE      no-undo.
  
  
  do with frame {&frame-name}:

    
    /* Rebuild the query */
    if valid-handle(brConnections:query) then do:
      brConnections:query:query-close().
      delete object brConnections:query.
    end.
    
    create query hQuery.
    
    hQuery:set-buffers(buffer ttConnection:handle).

    /* Build the query */
    cQuery = 'for each ttConnection where true'.
    cQuery = substitute("&1 by &2 &3", cQuery, cNewSort, string(lAscending,'/descending')).
    hQuery:query-prepare(cQuery).
    hQuery:query-open().
    hQuery:get-first.

    /* Attach query to the browse */
    brConnections:QUERY in frame {&frame-name} = hQuery.

The error occur when last code line executed.
It run fine with Progress 10.2A, but failed with progress 9.1.

Please help!

 

[KrisM]

What is the value of cNewSort when the error is raised ?