question

Mark S3 avatar image
2 Likes"
Mark S3 asked Phil BoBo answered

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?

FlexSim 17.1.6
dll
iwmcpwsoqoq8cxrj8k2.png (19.4 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Phil BoBo avatar image
1 Like"
Phil BoBo answered

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.

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.