Repository navigation
Unable to execute custom sql query #29
Description
Hi Navigraph team,
I am trying the sample airplane that you provided.
May I ask how to successfully run the custom sql query?
Current I have:
ExecuteSQLQuery("SELECT * FROM tbl_hdr_header;", "")
However the db gives me:
{
"line": 19738,
"column": 35,
"sourceURL": "xxxx"
}
Could you possibly provide some examples of using this function including / excluding the params?
Thanks a lot!
Activity
SkySails commentedon Nov 20, 2025
Hello! Thank you for the feedback!
We have looked into this, and there are at least two different reasons why you get an error:
We're looking into the second reason and related things in #30 !
Kuailun commentedon Nov 20, 2025
Hi! Thanks for getting back to me!
I am using this DB: https://github.com/Navigraph/msfs-navigation-data-interface/tree/main/example/aircraft/PackageSources/Navigraph
By opening with Pycharm, I can see the table and the table:
Kuailun commentedon Nov 20, 2025
I have two additional questions:
Thanks again for the help!
pepperoni505 commentedon Nov 20, 2025
Hi,
We are looking into your first question.
Regarding the second, the sample has been fixed in #30. There was a bug on our end that added a param to arguments that didn't have any which caused that issue. When using the
ExecuteSQLQuerycall, you need to pass an array of strings for the params. If there are none, you can leave the array empty. You can look at this file for the list of CommBus calls and their expected bodies.Please let us know if you have any more question!
/ Jack
SkySails commentedon Nov 20, 2025
I have tried to run your query with the changes in #30, and it works as expected:
Please confirm if this is the case for you too!
Kuailun commentedon Nov 20, 2025
Thanks!
I am able to execute the query as well.
SkySails commentedon Nov 21, 2025
Thank you for the confirmation!