Hi
Is it possible for RTMC Pro 4 to use SQL script to query a server?
thanks for your help
Hi,
Not sure if you can use SQL scripts directly but one around this is to create a table on the server using the required script and then just use that table in RTMC. I bring in external data by creating a 'Loggernet' format table in mySQL, putting data into it via external routines and then using that table in RTMC as per true Loggernet tables.
If you made the table a view then that may solve your problem.
Not sure if this helps or not...
Cheers,
Scott.
Hi Scott,
that seems reasonable, how do I set the new table up so it is a 'Loggernet' format table to be readable in RTMC?
Martin.
Hi,
See the recent post on RTMC Pro and SQl databases as that answers some of your questions. Basically it has to have the right format in terms of primary keys and has to be described in some metadata tables - again see the post.
Cheers,
Scott.