I'm testing remote automation. The goal is to setup an automation server to which you can SQL-selects commands and get back results. I've managed to do this using automation server, remote automation, etc ...
In brief here's what the automation server does :
- add to the selec - sql command : "into table c:\temptable"
- execute the query
- open the table with fopen, read in the whole table in one string
- send this string to the remote client connected to the server
Then client FWRITE's the string to it's local disk and hocus pocus : it works !! For now I didn't implement support for memo fields yet but an extension of this method should work ...
Now the questions are :
- are there concequences using the lowlevel filefunctions. It doesnt' seem to be the most elegant way ... (but it works ...)
- is it possible to receive data directly into a cursor. For the client side ADO could come in the game, but I was wondering can ADO be implemented also in my automation server, or does ADO is a pure client thing not server ?
- if ADO isn't a solution, are there besides the lowlevel filefunctions techniques that I could use to send over the data ? I'm thinking about routines that can convert a cursor into a single string and back ?