Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Web and WebWorks Development

New Contributor
Posts: 4
Registered: ‎02-22-2012
My Device: Blackberry v6.0
My Carrier: Blackberry

HSQL query is not working in Blackberry 7.0

Hi All,


I have developed an application using Rhomobile. The HSQL queries are not running in Blackberry 7.0 simulator. 

1) Which query is supported in Blackberry 7.0?


I am using the following HSQL query in my application.


total_summary = Customer.find_by_sql("SELECT customer.cus_last_name,cast(Round(sum(inv_due_amt),0)as int) AS PORTFOLIO FROM Invoice,Customer Where customer.cus_id = invoice.cus_id and invoice.cus_id = 2346")


I am getting the "undefined column customer.cus_id not found"  in BlackBerry 7.0 simulator.


But the same query works in Blackberry 6.0 and 5.0


Please help me to fix this issue.