SQL table Connect

[a4225283]

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.

[a4225283]

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.

[a4225283]

@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.

[FelixMoehlmann]

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....

[a4225283]

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).