From a technical perspective, SIC adds a layer of abstraction to the communication between OS and external system, but from a .NET perspective there should not be a difference, as long as the Gateway configuration allows write-back. That being said, I just read that the specific .SaveCustomDataTable is NOT supported, so you would need a different approach, but you have a lot of options, eg, create INSERT/UPDATE sql statement. More info on SIC can be found here: SIC Info
I want to create a table and columns in SIC, but only the table name is being created. I want to know how to fix this problem. Below is my sample query and code :
Dim sql as new text.stringbuilder
Sql.appendline(“Create Table employee(Name varchar(255) not null ,age int null);”
using dbconnap as dbconninfo = brapi.database.createexternaldbconninfo(si,”SICconnectionname”)
Brapi.database.executesql(dbconnapp,sql.tostring,true)
end using
