question

Long Tang avatar image
1 Like"
Long Tang asked Steven Hamoen edited

How to insert rows to the database table?

In the flexsim command,there is dbgettablenum() to read the data from the database and dbsettablenum() to update data to the table.but there is no command to insert or delete data.how to operate it?

FlexSim 7.5.4
databaseodbcoracle
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

Sam Stubbs avatar image
1 Like"
Sam Stubbs answered Steven Hamoen edited

I think you can do this using dbsqlquery() command. By sending a query you should be able to do whatever commands you would do for your database by passing it with the dbsqlquery() command. (Such as an INSERT INTO command if you are using SQL for your database.) dbsqlquery() as a command just passes whatever SQL statement you give it in its parameter to your open db.

As side note: In order to use the dbsqlquery() command you'll need to open the db in sql mode. You can learn more about that information by looking up the dbopen() command in the Command Help in FlexSim.

5 |100000

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