B4J Question Additional SQL queries with jRDC

[Adie]

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]

(would need more than 100 SQL queries in the config file

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]

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]

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]

Thought someone did it already (lazy me)
Busy with that now. first must 'desect' the code.

A

 

[OliverA]

Thought someone did it already (lazy me)

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]

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