Android Question Help in RDC Select Command

[selvamurali]

Dear Team

i used Remote Database Connector(RDC) to connect My Remote database its working fine.

When i use the Query like select * from items . its retrieve all records

the problem is when i use select * from items where category = ? . it show the logs column names only not retrieve any records. i .

i pass the parameter string like
Dim cmd As DBCommand'
cmd.Initialize
cmd.Name = "select_itemnames"
cmd.Parameters = Array As Object("Fruits")
reqManager.ExecuteQuery(cmd, 0, Null)

Tag: null, Columns: 6, Rows: 0

categoryname heading description weburl coupencode mobileno
** Activity (main) Resume **
** Activity (main) Pause, UserClosed = false **
** Activity (main) Create, isFirst = true **
** Activity (main) Resume **

 

[Erel]

Can you post the output of printTable with the query that returns all the results?

 

[selvamurali]

This is the PrintTable Result for Select * from Items
Tag: null, Columns: 6, Rows: 2


categoryname heading description weburl coupencode mobileno

Mobile Phones Smartphone offer exchange your old smartphone and get new one www.flipcart.com 456787 0443421345

Fruits Apple Offer Buy 1kg Apple and get 1Kg free www.fruitsbuy.com 34256 04342252425


and this is the Printtable reults for Select * from Items where categoryname = Fruits
Tag: null, Columns: 6, Rows: 0

categoryname heading description weburl coupencode mobileno

 

[Erel]

The column name is categoryname not category.

 

[selvamurali]

i used the column name categoryname but still same problem.

 

[Erel]

The problem is somewhere with your data. Make sure that the value of categoryname is indeed Fruit and doesn't have any extra space.