SQL query on global table from c++

Question

question

anon-user asked Sep 30, '21 anon-user commented Oct 4, '21

SQL query on global table from c++

Hi,

I would like to know, if there is a way of running an SQL request on a global table in C++. I have seen this old question in the forum: https://answers.flexsim.com/questions/58035/how-to-use-sql-queries-in-a-dll-project.html . Any changes on this?

I have seen the private static method "cpp_query" in the Table class and some public overlays, but am not successful to call them. Can you share an example how to call it properly?

If not, is there a workaround e.g. call/eval a small flexscript from c++?

Kind regards,

Lothar

global table sql c++

· 1

Ryan Clark commented · Oct 01, 2021 at 11:11 PM

Hi @Lothar K, was Phil BoBo's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 ·

Answer 1 · 2021-09-30T14:31:12Z

Phil BoBo answered Sep 30, '21 anon-user commented Oct 4, '21

You can use nodefunction(), function_s(), executefsnode(), or executestring() to execute FlexScript from C++.

· 3

anon-user commented · Sep 30, 2021 at 02:59 PM

Thanks a lot for the answer. I will try that workaround. So I assume from your answer, that there is no (public) way to call "Table.query" from C++ directly.

0 ·

Phil BoBo ♦♦ anon-user commented · Sep 30, 2021 at 03:22 PM

There are several C++ query functions that may work better now than when that other question was asked.

There's a visible cpp_query() function in the Engine and a query() macro defined in CppLambdaCommands.h that calls it. I'm not sure whether that is working better now than it used to; it might be.

There's also the static method on the Table class that you mentioned. Try this:

Table table = Table::cpp_query("SELECT * FROM GlobalTable1", CppQueryLambda());

0 ·

anon-user Phil BoBo ♦♦ commented · Oct 04, 2021 at 11:08 PM

Thanks a lot. The CppQueryLambda() made the difference. I failted bedause I tried a nullptr argument there.

0 ·

question