Android Question [SOLVED] JRDC2 IN Operator

[IlCasti]

Sorry, pheraps this is a noob question..
How can i use IN operator with JRDC2?

Dim cmdList As DBCommand = Db.CreateCommand(Query, Array (X,"763043,763054,755123,759006"))

This return 0 records

This is in properties.config

sql.xxx=SELECT Cat, prod, x FROM supprod where id = ? and idprodotto in(?)

Thank you all.

 

[OliverA]

Each value in IN needs a ?, so in the example above you would need this in properties.config

sql.xxx=SELECT Cat, prod, x FROM supprod where id = ? and idprodotto in(?,?,?,?)

and your DBCommand needs to be set like this

Dim cmdList As DBCommand = Db.CreateCommand(Query, Array (X,"763043","763054","755123","759006"))

If your IN parameters are always fixed (like in this case with 4 elements), then the above will work great. If your IN parameters can vary, but only between a few cases, then this link (https://www.b4x.com/android/forum/t...martphone-to-jrdc2-server.111269/#post-693960) may provide a solution. If your IN parameters are completely random in quantity, then you'll have to do some coding and use dynamically created SQL statements.

 

[IlCasti]

Thank you Oliver
My parameters can vary so i don't know how many will be used in query and they are completely random.

If your IN parameters are completely random in quantity, then you'll have to do some coding and use dynamically created SQL statements.

In RDCHandler? Or where?
Can you tell me how can i do it? Some help shall be appreciated.

Bye

 

[IlCasti]

Thank you Oliver
I read this thread linked into your first linked address

https://www.b4x.com/android/forum/t...martphone-to-jrdc2-server.111269/#post-693960

and i solved my situation use a query without params after replacing them in command rdc connector and doing some other coding change.

I never had read jrdc code before.

Thank you again.
Bye!