Hi all,
I have an edit page that I'd like to use the built in event "Save old data record in a different table" but I'd like to insert it into a table that is in a different database on a different server (different data connection).
Here is the default event that comes from adding the built in event:
INSERT INTO AnotherTable (Field1, Field2) SELECT Field1, Field2 FROM " + GlobalVars.strTableName.ToString() + " where " + where.ToString()
How would I alter this to use a different data connection?
By the way, the different data connection I want to use is added to this project already on the "Tables" page of ASPR.
Thanks,
Tim