B4J Question [SOLVED] Passing Parameter in jRDC2

BillMeyer · Feb 26, 2019

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 · Feb 27, 2019

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

B4J Question [SOLVED] Passing Parameter in jRDC2

BillMeyer

Well-Known Member

BillMeyer

Well-Known Member

Similar Threads

B4J Question [SOLVED] Passing Parameter in jRDC2

BillMeyer

Well-Known Member

BillMeyer

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency