Search two tables with SQLite
Quote from m.burdess on August 4, 2021, 3:44 pmCan you search two tables within an SQlite database, if the layout is the same i.e.
one table is called AM and the second is called NZ. both have a field named Place.
Can you search two tables within an SQlite database, if the layout is the same i.e.
one table is called AM and the second is called NZ. both have a field named Place.
Quote from luishp on August 5, 2021, 11:46 am@m-burdess you can use any SQL Query including INNER JOIN:
https://www.sqlitetutorial.net/sqlite-inner-join/
Regards.
@m-burdess you can use any SQL Query including INNER JOIN:
https://www.sqlitetutorial.net/sqlite-inner-join/
Regards.
Quote from luishp on August 5, 2021, 7:03 pm@m-burdess right now I have no time to prepare a complete sample sorry, but I'm sure some users already have done this before and perhaps they would like to help here. Anyway, if you get stuck, please prepare a sample I can modify so I don't need to start from zero and will try to help you.
Best regards.
@m-burdess right now I have no time to prepare a complete sample sorry, but I'm sure some users already have done this before and perhaps they would like to help here. Anyway, if you get stuck, please prepare a sample I can modify so I don't need to start from zero and will try to help you.
Best regards.
Quote from m.burdess on August 5, 2021, 8:47 pm@luishp thank you for the help, the web site you sent me too is good. I can not see the code in context with where its needed within the Visualneo.
Within the config.sys file, do I add it to the search function or "Loadtable", this is the area missing for me.
@luishp thank you for the help, the web site you sent me too is good. I can not see the code in context with where its needed within the Visualneo.
Within the config.sys file, do I add it to the search function or "Loadtable", this is the area missing for me.
Quote from luishp on August 6, 2021, 11:25 amHi @m-burdess,
neoPhp works this way:
- You use neoPhpExecSql to execute a SQL stored in your config.php file.
- The query results are sent to a subroutine (ie: parseData)
- You process the data in the subroutine.
That's all. So you just need to define to appropiated SQL queries into your config.php file and to take a look at the "data" retrieved by them into your subroutine. I allways recommend using Consolelog command to see what's coming from the server.
Best regards.
Hi @m-burdess,
neoPhp works this way:
- You use neoPhpExecSql to execute a SQL stored in your config.php file.
- The query results are sent to a subroutine (ie: parseData)
- You process the data in the subroutine.
That's all. So you just need to define to appropiated SQL queries into your config.php file and to take a look at the "data" retrieved by them into your subroutine. I allways recommend using Consolelog command to see what's coming from the server.
Best regards.