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!