Adie Member Licensed User Longtime User Feb 22, 2018 #1 Hi I need to execute various user defined queries via jRDC. (would need more than 100 SQL queries in the config file ) Tried all I know but could not 'bypass' the sql.queryname
Hi I need to execute various user defined queries via jRDC. (would need more than 100 SQL queries in the config file ) Tried all I know but could not 'bypass' the sql.queryname
DonManfred Expert Licensed User Longtime User Feb 22, 2018 #2 Adie said: (would need more than 100 SQL queries in the config file Click to expand... you can place more than 100 in the config file without problem. But they are fixed (as they are in the configfile) and not userdefined. Upvote 0
Adie said: (would need more than 100 SQL queries in the config file Click to expand... you can place more than 100 in the config file without problem. But they are fixed (as they are in the configfile) and not userdefined.
Adie Member Licensed User Longtime User Feb 22, 2018 #3 Ok, let me rephrase, I need to pass the fully parsed SQL query I generate at runtime to the server. I do not know the possible user queries beforehand. Adie Upvote 0
Ok, let me rephrase, I need to pass the fully parsed SQL query I generate at runtime to the server. I do not know the possible user queries beforehand. Adie
Erel B4X founder Staff member Licensed User Longtime User Feb 22, 2018 #4 If you understand jRDC2 code then you can implement it. Either with a new handler or in the existing handler. Pass the query and run it. Upvote 0
If you understand jRDC2 code then you can implement it. Either with a new handler or in the existing handler. Pass the query and run it.
Adie Member Licensed User Longtime User Feb 22, 2018 #5 Thought someone did it already (lazy me) Busy with that now. first must 'desect' the code. A Upvote 0
OliverA Expert Licensed User Longtime User Feb 22, 2018 #6 Adie said: Thought someone did it already (lazy me) Click to expand... This? https://www.b4x.com/android/forum/threads/another-customised-version-of-jrdc2.72082/#content Update: Note @Erel's comments/warnings in that thread Upvote 0
Adie said: Thought someone did it already (lazy me) Click to expand... This? https://www.b4x.com/android/forum/threads/another-customised-version-of-jrdc2.72082/#content Update: Note @Erel's comments/warnings in that thread
Adie Member Licensed User Longtime User Feb 22, 2018 #7 THANKS, EXACTLY WHAT I NEEDED. No problem with security, the app will run on a 'closed' network with only the server and a Pi connected. Adie Upvote 0
THANKS, EXACTLY WHAT I NEEDED. No problem with security, the app will run on a 'closed' network with only the server and a Pi connected. Adie