B4J Question [SOLVED] Passing Parameter in jRDC2

BillMeyer

Well-Known Member
Licensed User
Hi Fellow B4Xers,

I have strange issue. I am using jRDC2 Client in B4J and would like to query a MySQL table

When I use this command, I get a result returned
B4X:
    Dim req As DBRequestManager = CreateRequest
    Dim cmd As DBCommand = CreateCommand("ad_SYS1_UnitActive", Array("350183343201117"))
but when I do it this way around, I get no result
B4X:
    Dim IMSI As String = "350183343201117"
    Dim req As DBRequestManager = CreateRequest
    Dim cmd As DBCommand = CreateCommand("ad_SYS1_UnitActive", Array(IMSI))
I am either missing something or I am going mad.

Can someone help please ?
 

BillMeyer

Well-Known Member
Licensed User
This is one of those cases where a day and a half have been wasted due to wrong data entry and accepting it as correct.

I typically focused on the code to find the error, whilst in the database (manually entered data for testing purposes) was a little switching of characters - so obviously the record will never be found because to MySQL "350183443201117" and "350183343201117" are two different things and your eyes tend to play tricks on you with such a long item.

So the conclusion: I was missing something - I'm still not mad !! :eek:
 
Top