Hi zwc
Here is the code I use and it works:
Using dbConn As DbConnInfo = BRApi.Database.CreateDbConnInfo(si, DbLocation.External,"[[your SIC Connection name]]")
'.CreateCustomExternalDbConnInfo(si, DbProviderType.Gateway, "GRDWDB")
dt = BRApi.Database.ExecuteSql(dbConn, insertStatement, False)
End Using
The insertStatement variable is a string that contains an insert statement. But your problem, I believe, is the dbConnInfo.
Cheers!
I tried with SaveCustomDataTable and received a message saying it is not compatible with SIC. So for now, my best answer is with the insert statement which will only work with a small number of records
