topic SQL INSERT INTO Global Table Errors in FlexSim Forum

SQL INSERT INTO Global Table Errors

stan_e_davis — Tue, 06 Sep 2022 20:55:49 GMT

[ FlexSim 22.2.1 ]

I'm developing a procedure to populate a global table using the 'INSERT INTO' statement. For testing I have a simple global table with all data assigned as numbers...

When I run the following statement in the script console..

Table.query("INSERT INTO RackVolumeTable2 (Rack, Bay, Level, Slot, Volume) VALUES ($1, $2, $3, $4, $5)",  1, 2, 3, 4, 5.11);

I get the following error..

When I run the statement in debug mode, I get this error..

I've tried just inserting a single value but get same errors. I believe the statement is constructed correctly as any variation will result in parsing errors.

Per documentation, the "INSERT INTO" is supported. What is the issue?? Thanks - Stan

Re: SQL INSERT INTO Global Table Errors

jason_lightfoot_adsk — Tue, 06 Sep 2022 21:57:30 GMT

Concatenate the values into the SQL string rather than using parameters.

Re: SQL INSERT INTO Global Table Errors

stan_e_davis — Tue, 06 Sep 2022 22:25:24 GMT

Thanks Jason. That worked...

Table.query("INSERT INTO RackVolumeTable2 (Rack, Bay, Level, Slot, Volume) VALUES ( " + 1 + ", " + 2 + ", " + 3 + ", " + 4 + ", " + 5.11 + ")");

Re: SQL INSERT INTO Global Table Errors

jason_lightfoot_adsk — Tue, 06 Sep 2022 22:28:07 GMT

Great! And if you need to insert strings just put apostrophes around the string.