I have an XML file, that I bring into a dataset that has 4 temp-tables. I CAN see the data in the temp-tables, BUT where I am confused (LOST) is the fact that I don't see the below process creating the relationships between the temp-tables. I would expect the "parentid" fields to be populated...
I need to parse and load a JSON object with dynamic keys. Is it possible to do so with OE. I am running OE 11.3
Extract from JSON looks at follows
"aircraft": {
"319": "AIRBUS A319",
"333": "AIRBUS A330-300",
"738": "BOEING 737-800",
"739": "BOEING 737-900"...
**Below is my samplecode to read data from xml file and write to temp-table "tttemp" and display a child "mainsub" and its sub-child nodes.**
DEFINE VARIABLE hDoc AS HANDLE NO-UNDO.
DEFINE VARIABLE hroot AS HANDLE NO-UNDO.
DEFINE VARIABLE hmainsub AS HANDLE...
I have a program that takes a temp-table, reads it into a json object then uses that Json to call a rest service i need to tweak it so that it only sends on record at a time until all the records are sent.
is there anyway to do this dynamically, or do i need to break the data and build the json...
Hi All, need your help on a requirement. it goes like:
i have a delimited file with unknown numbers of columns. i can able to create a dynamic temp-table and populate entire data properly in that temp-table.
Now i want to copy all these records to a static temp-table which is nothing but a...
I have a custom report that uses a temp table defined like a database table that is receiving this error:
** temp_ld_det already exists with 0. (132).
It seems that since our last upgrade, QAD has added an index to that table which is causing the issue. Is there a way for me to exclude this...
Hi all,
Quick question, is using lock statements (no-lock, exclusive-lock) when doing searches on temp tables considered bad coding standards? See example below. Now before anyone says anything note the below is a simple example for illustrative purposes only.
DEFINE TEMP-TABLE...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.