I work on a system configured like this:
Broker X is connected to database X1.
Broker Y is connected to database Y1.
I have an embedded speedscript html file running on broker X. From that page I need get data from Y1. I havn't really found a nice way to do it. Assuming I can't change the Brokers configuration what can i do?
Thank you.
Olivier.
Well, certainly the easiest would be to connect both databases.
2nd easiest might be to set up an AppServer connected to DB Y1 and connect to that AppServer from X.
If all that's not an option, a http request from X to Y running a webspeed program, that outputs and (XML) formatted document might be another option. If you need to pass temp-table data serializing that temp-table (:WRITE-XML) is the way to format the data.
The 4GL src/samples/socket (or similar) directory contains a sample program that demonstrates the use of sockets to do http requests. You should be able to use that from WebSpeed programs as well.
Mike
Sorry been a while.
Jumping from x to y did it. I didn't need to use XML that page's purpose was only to display some data. so from profram x I just had a link pointing to an html page connected to broker Y and I could see the data with no problem.
Thanks.