4 weeks ago
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
Solved! Go to Solution.
3 weeks ago
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.
4 weeks ago
What version of SIC are you using? I know I've seen issue with version 7.4 not on creating tables but queries not returning column headers if a query doesn't return any records. OS Support indicated that my issue is fixed in latest v8 version and maybe yours also?
4 weeks ago
I am using v8 version but somehow it is not working. I can see table but not columns
4 weeks ago
When you say you can see the table but not columns, what are you viewing table in? Sounds very strange.
What database is it?
Have you tried inserting a row of data after you created it?
Something like,
sql.AppendLine(“INSERT INTO employee(Name,age) VALUES ('TestName',20);”
3 weeks ago
I have inserted few rows as well and it is running fine. When i ran query in my data adapter it is not fetching anything.
3 weeks ago
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.