topic Re: MYSQL dbsettablenum error in FlexSim Forum

MYSQL dbsettablenum error

xucq — Mon, 07 Jun 2021 01:45:10 GMT

[ 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

Re: MYSQL dbsettablenum error

Jeanette_Fullmer — Mon, 07 Jun 2021 18:31:50 GMT

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

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

contact information / 联系方式:
wangyang@csn-bj.com / support@csn-bj.com
QQ: 1093796825
@CSN

Re: MYSQL dbsettablenum error

supportPHJ4A — Tue, 08 Jun 2021 07:42:53 GMT

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.

Re: MYSQL dbsettablenum error

philboboADSK — Tue, 08 Jun 2021 14:03:01 GMT

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

Re: MYSQL dbsettablenum error

supportPHJ4A — Wed, 09 Jun 2021 01:31:57 GMT

Hi , Phil,

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

Re: MYSQL dbsettablenum error

philboboADSK — Wed, 09 Jun 2021 13:01:47 GMT

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.

Re: MYSQL dbsettablenum error

xucq — Thu, 10 Jun 2021 08:54:51 GMT

Hi, Phil

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