Android Question [Solved] How to use MySQL LIMIT clause in jRDC2?

(a.CODPROV >= ? AND a.CODPROV <= ?)

Click to expand...

to

a.CODPROV BETWEEN ? AND ?

Click to expand...

ref:

looking at the java code (PreparedStatement) :

public ResultSetWrapper ExecQuery2

and this other:
con.ExecQuery2(Main.rdcConnector1.GetCommand(cmd.Name), cmd.Parameters)

I think passing parameters as object type should work.

Change:

P.S: (nLimit)
Limit values must be integers.

I got excited studying the problem.

?????

oparra said:

looking at the java code (PreparedStatement) :

public ResultSetWrapper ExecQuery2

B4J_SQL/src/anywheresoftware/b4j/objects/SQL.java at master · AnywhereSoftware/B4J_SQL

B4J SQL library. Contribute to AnywhereSoftware/B4J_SQL development by creating an account on GitHub.

github.com

and this other:
con.ExecQuery2(Main.rdcConnector1.GetCommand(cmd.Name), cmd.Parameters)

B4X:

Public Sub GetCommand(Key As String) As String
    If commands.ContainsKey("sql." & Key) = False Then
        Log("*** Command not found: " & Key)
    End If
    Return commands.Get("sql." & Key)
End Sub

I think passing parameters as object type should work.

Change:

B4X:

Dim aCom() As Object = Array (nCar,cFiltro,MinPro,MaxPro,MinLin,MaxLin,MinRub,MaxRub, nLimit)

B4X:

GetRecord (Command As String, parameters() As Object) As ResumableSub

P.S: (nLimit)
Limit values must be integers.

I got excited studying the problem.

?????

Click to expand...

Hi @oparra, @OliverA

Thank you very much for your patience and detailed explanations. It finally WORKS by making those little changes.

NOTE: At first I thought that if I modified "GEtRecord" from String to Objet, I had to change ALL the calls (currently my APP has more than 100), but obviously B4X internally makes the passage from String to Objets automatically, since I did not have I had to modify none and the APP kept connecting correctly !!! .... a genius!
Basically when I need a variable "LIMIT" from the APP, I use this syntax, otherwise I keep sending a string array and it works.

A million thanks!!!??