SQL INSERT INTO Global Table Errors

Question

question

Stan Davis asked Sep 6, '22 Jason Lightfoot commented Sep 6, '22

SQL INSERT INTO Global Table Errors

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

Software Version:

FlexSim 22.2.1

sql sql queries

1662497134543.png (6.0 KiB)

1662497224820.png (13.6 KiB)

1662497628819.png (9.9 KiB)

5 |100000

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

Answer 1 · 2022-09-06T21:57:30Z

Jason Lightfoot answered Sep 6, '22 Jason Lightfoot commented Sep 6, '22

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

· 2

5 |100000

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

Stan Davis commented · Sep 06, 2022 at 10:25 PM

Thanks Jason. That worked...

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

1 ·

Jason Lightfoot ♦♦ Stan Davis commented · Sep 06, 2022 at 10:28 PM

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

0 ·

question