I am sending XML from UniVerse to a webserver using callHttp. Currently
we're on UV10.0.7 and won't be upgrading to a version of UV with
XMLExecute() any time soon.
The current technique is to "EXECUTE 'LIST CUSTOMERS ... TOXML' CAPTURING
postData". This works fine for relatively small amounts of data but it
doesn't take long for the amount of XML to blow the workspace when postData
gets a few thousand rows into it.
I was just wondering if there was some technique someone has worked out to
get the 'next set' of records using an active select list.
eg.
SELECT CUSTOMERS
LOOP WHILE ACTIVE.LIST DO
EXECUTE 'LIST ... NEXT 5000 TOXML' CAPTURING postData
REPEAT
My next option is to issue a select and then manually build select lists
for each set of rows. This would be somewhat cumbersome and add overhead to
something that needs to be efficient.
Or maybe there's some cute SQL syntax???
Any suggestions?
--
Regards,
Stuart Boydell
**********************************************************************
This email message and any files transmitted with it are confidential
and intended solely for the use of addressed recipient(s). If you have
received this email in error please notify the Spotless IS Support Centre (61 3
9269 7555) immediately who will advise further action.
This footnote also confirms that this email message has been scanned
for the presence of computer viruses.
**********************************************************************
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
