[progress Communities] [progress Openedge Abl] Forum Post: Re: Dynamic Query

[Brian K. Maher]

The error is caused because the address buffer is not in scope. There is no reference to this table earlier in the code. If you want to access this table dynamically without a prior reference then I would refer you to the doc: FOR TABLE table-name | table-handle | buffer-handle A character expression ( table-name ) that evaluates to a unique database table name or static temp-table name, a temp-table handle ( table-handle ), or to an existing buffer object handle ( buffer-handle ), each of which can specify the record source for which to create the buffer object. If table-name is ambiguous, you must qualify the database table name with a database name or rename the temp-table. Otherwise, if the database table exists in multiple connected databases, the AVM creates the buffer in the first connected database So... // note the double quotes CREATE BUFFER lv_buffers FOR TABLE "address".

Continue reading...