How to use SQL queries in a DLL project?

Question

question

Mark S3 asked Oct 25, '18 Phil BoBo answered Oct 29, '18

How to use SQL queries in a DLL project?

When I build a DLL function, I need to use the query function to query a global table.

But I found that the code copied directly FROM the flexsim code editor, such as query("SELECT A FROM TableName WHERE B >0"), will report an error in visual studio.

I've tried many ways, but none of them worked.

How can I solve this problem?

Software Version:

FlexSim 17.1.6

dll

iwmcpwsoqoq8cxrj8k2.png (19.4 KiB)

Answer 1 · 2018-10-29T19:35:00Z

Phil BoBo answered Oct 29, '18

Using FlexSim's SQL query() command may have worked in C++ at some point, but I don't think it does currently.

If you want to use query() or Table.query(), you might need to execute FlexScript to do so right now.

question