AnswerHub Upload Issue
Our AnswerHub community currently has a bug that prevents you from attaching your model or other files to your questions. AnswerHub is aware of this issue and they are working on a fix. Until we receive their patch, you can upload your models and other files to FlexSim's file share site. Include the file name in your question so that we know which upload to reference.

question

ANIL KUMAR N avatar image
0 Likes"
ANIL KUMAR N asked Emily Hardy commented

rows are not loading into global table from database table

I have a database table which consists of around 1000 rows(appr.). All the rows are shown in oracle database. Whenever I try to connect to table by running query in DBConnector it's not importing the data from table and it's showing an empty global table. How to resolve this issue? This happens with only few tables.

FlexSim 18.1.1
flexsim users manualflexscript error
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

·
Jordan Johnson avatar image
0 Likes"
Jordan Johnson answered Emily Hardy commented

Can you import through the API? It may be that the auto-import code isn't correct in some cases. Once you set up your connection, try this code (modifying variable names, etc.)

Database.Connection con = Database.Connection("DBConnector1");
con.connect();

Database.ResultSet set = con.query("SELECT * FROM mytable");

Table table = Table("GlobalTable1");
int tableSizeCorrect = 0;
int rowCount = 1;
while (set.fetchNext()) {
	if (!tableSizeCorrect) {
		table.setSize(1, set.numFields);
		tableSizeCorrect = 1;
	}

	if (table.numRows < rowCount)
		table.addRow();
	
	for (int i = 1; i <= set.numFields; i++) {
		Variant val = set[i];
		table[rowCount][i] = val;
	}

	rowCount++;
}
· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

@ANIL KUMAR N, did this answer your question?

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.