topic Re: SQL table Connect in FlexSim Forum

SQL table Connect

a4225283 — Thu, 27 Nov 2025 06:12:21 GMT

I need to confirm something! Can I use an SQL table as the destination for my vehicle? How do I do this? Also, how do I maintain communication with the constantly updated table? Furthermore, if communication is possible, do I need to immediately report the vehicle's location to the table? How do I do this?

This image shows three vehicles that need to have their names retrieved from a table and then proceed to their destinations. Once a vehicle arrives at its destination, it should report its location.

Re: SQL table Connect

a4225283 — Fri, 28 Nov 2025 08:19:54 GMT

For example, I want to set the destination to a field in the select database and then read it. How can I do this?

I've noticed very little discussion about databases on the forum. I'd like to ask if it's necessary to write an API to handle queries, perhaps using a reinforcement learning approach.

Re: SQL table Connect

a4225283 — Tue, 02 Dec 2025 09:40:34 GMT

@FelixMoehlmann

Sir, do you know how I should get started with this? The ultimate goal is something like Flexsim reinforcement learning, where it queries the actual system to perform actions. What I need to do is simulate real-world devices issuing requests and then use the real system to assign Flexsim's RGVs to designated points for loading and unloading.

Re: SQL table Connect

FelixMoehlmann — Wed, 03 Dec 2025 08:07:50 GMT

FlexSim offers the a database connection functionality in the toolbox. You can use that to query external databases in some interval and trigger logic based on the results. A query can also update values in the database to write data back to it.

https://docs.flexsim.com/en/25.2/Reference/Tools/DatabaseConnectors/DatabaseConnectors.html

https://docs.flexsim.com/en/25.2/Reference/CodingInFlexSim/FlexScriptAPIReference/Database/Database.Connection.html

Re: SQL table Connect

a4225283 — Wed, 03 Dec 2025 10:35:06 GMT

I want to know how to implement a function to periodically query a database!

Or, after being triggered by an event, he might query the database (after entering q->find sql).