MYSQL dbsettablenum error

[xucq]

[ FlexSim 18.1.2 ]

Hi , my database can be connected, and I can read number from it. But when I use the dbsettablenum command , the error appeared. Thanks for your answer.数据库demo.fsm

[Jeanette_Fullmer]

Please contact our Chinese partner, BJCSN. They can provide you with direct assistance.

为了更好更快速的解决您的问题，可以联系我们当地中国区合作伙伴 (北京创时能)，他们会为您提供专业的FlexSim技术答疑.

contact information / 联系方式:
[email protected] / [email protected]
QQ: 1093796825
@CSN

[supportPHJ4A]

Hi , this is the problem of our Chinese users. Our engineers cannot find the cause of the problem. Please help to have a look , thanks a lot.

[philboboADSK · Accepted solution]

The deprecated legacy db...() commands and the Database Connector are two separate tools. Don't use the db...() commands. Use the Database FlexScript API.

[supportPHJ4A]

Hi , Phil,

I know what you said, the version is 18.1 , and the dbgettablenum command is ok , except the dbsettablenum is not ok.

[philboboADSK]

I understand that the version is 18.1. I understand that the dbgettablenum() command worked for you. The dbsettablenum() command doesn't. The db...() commands are all poorly designed, slow, and buggy. Don't use them. We've replaced them with a much better way to communicate with databases. Use the new way, not the broken, old way that does not work well and we do not support anymore.

Use the Database Connector object and the Database.Connection API. Both are available in FlexSim 18.1. See Help > FlexScript API Reference > Database.Connection. If you want to write to a database, use an INSERT INTO SQL statement. See the example in the description of Database.PreparedStatement in FlexSim 18.1's FlexScript API documentation.

[xucq]

Hi, Phil

Thanks for your answer, I will tell my user to use the new way.