MP2
4 months agoNew Contributor II
Create Table in SIC
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
The business rule implementation issue has been resolved. The CSV-to-DataTable conversion was defaulting all columns to string data type. Defining explicit data types for each column resolved the issue.