question

Shinya O avatar image
0 Likes"
Shinya O asked Jason Lightfoot answered

Error when deleting all rows in table query

Hi,

An error occurs when executing a query against the following global table. Is this a bug? Is there a workaround?


 Col 1 Col 2
Row 1 0 1
Row 2 0 2 
Table.query("DELETE FROM GlobalTable1 WHERE [Col 1]==0")

If you check "Use Bundle", there will be no error, but if not, an error will occur.

Thanks in advance.sql-delete-error.fsm

FlexSim 24.1.0
sql queriesdelete
sql-delete-error.fsm (25.3 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered

Thanks for pointing this out - it appears to be a bug, so we'll create an issue in the tracking system.

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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