B4J Question [SOLVED] Passing Parameter in jRDC2

[BillMeyer]

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

    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

    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]

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 !!