Hi,

Is there anyone that can give me some input on the following problem:

1. I have tried to make a procedure, returning a dataset, and taking an input char parameter (xml formatted query) but are facing some problems.

Xml query looks something like this:

The intention is to dynamically create a statement like this:

"FOR EACH zip WHERE zip.zipcode='01234'"

Then run the query and send the result to a dynamically created temp-table

code again, something like this:

DEFINE VARIABLE tth AS HANDLE.

CREATE TEMP-TABLE tth.

tth:CREATE-LIKE(wtable). /wTable = "Zip"/

tth:TEMP-TABLE-PREPARE("tt" + wTable).

Last thing is to fill this into a simple dynamically created dataset:

CREATE DATASET hDset.

hDset:SET-BUFFERS("BUFFER " + "tt" + wTable + ":HANDLE").

2. In order to test it all i need a procedure that call the procedure mentioned in pt.1 with parameters:

- input char xml-query,

- output dataset

and display the rows in the table.

Any help apprecciated!