Add-columns-from

[ddest]

RE: ADD-COLUMNS-FROM using a temp-table:

I have a static temp-table for which I've defined and prepared a simple dynamic query. I am trying to create a dynamic browse using that query, but when I use ADD-COLUMNS-FROM specifying my temp-table, a Progress error tells me the temp-table could not be found in the browse’s query (message #9159), even though I've assigned the query handle the browse's QUERY attribute.

I can find no evidence in the documentation of this method indicating any restriction on its use with temp-tables.

Can anyone tell me what I’m doing wrong?

 

[jongpau]

Hi there,

Try this when you create your query:

CREATE QUERY lhQuery.
lhQuery:ADD-BUFFER(BUFFER TempTableName:HANDLE).

and then do this to add the fields to the browse:

lhBrowse:ADD-COLUMNS-FROM(BUFFER TempTableName:HANDLE).

When I do it like that the browse gets created without any errors. Of course you can also assign the value of BUFFER TempTableName:HANDLE into a variable and then use that instead of using "BUFFER TempTableName:HANDLE" all the time.

HTH

 

[erick.rosales]

Hi... Could I use this for a Static Query... I mean...

A query that was created using DEFINE QUERY...

Thanks...