B4J Code Snippet jRDC2 Adding & Using Custom Queries Easily

Ola

Step 1:

Add this code to the RDCConnector

'add a command that does not exist
public Sub AddCommand(scommand As String, qry As String)
    scommand = scommand.tolowercase
    Dim skey As String = $"sql.${scommand}"$
    If commands.ContainsKey(skey) = False Then
        commands.Put(skey, qry)
        Log("AddCommand...")
        Log(scommand)
        Log(qry)
    End If
End Sub

Step 2:

Before you fire the Query call / when app starts.

Main.rdcConnector.AddCommand("select_animal", "select * from animal where name = ?")

You are good to go!

#SharingTheGoodness

 

[Erel]

This change will make jRDC2 insecure. You should only used it in safe environments (intranets).