The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
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 ...
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.
I am using v8 version but somehow it is not working. I can see table but not columns
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);”
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.
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.