have anyone used ExportToRDBMS method 1

[dvraggs]

I was thinking I could use this to append to a list that I keep. anyone have example of its use.
Thanks

 

[pwarr]

I have used it. What it will do is to create a table on the database that you connect to via the connection string and then insert all the rows of your query into that table
The table will have the same name as the name of the query in the data provider eg Query_1_with_UniverseName, so if you want the table to have a specific name then rename your query in the data provider panel.
If the table exists already it will delete all existing values and insert the values in your query
It can be used as a quick way to create tables and load data onto the database instead of loading through sqlloader or similar.

 

[dvraggs]

Thanks for the reply I have usred another method