Hello Michael… yes, there is only one copy of that particular database with 
that name… if it were a different d/b, it would error out on column names being 
nonexistent, right?

Regards,
Rolf (SpokaneDude)

On Jun 3, 2012, at 5:34 AM, Black, Michael (IS) wrote:

> My first suspiciion would be that you're pointing to 2 different databases.  
> Are you SURE the DB is the same between the 2 apps?
> 
> 
> 
> 
> 
> Michael D. Black
> 
> Senior Scientist
> 
> Advanced Analytics Directorate
> 
> Advanced GEOINT Solutions Operating Unit
> 
> Northrop Grumman Information Systems
> 
> ________________________________
> From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
> behalf of Rolf Marsh [rmma...@fastmail.us]
> Sent: Saturday, June 02, 2012 6:11 PM
> To: sqlite-users@sqlite.org
> Subject: EXT :[sqlite] Query runs in SQLite Database Browser but not in iPad 
> app
> 
> I have this select statement which returns the correct results (count = 2) 
> when run in SQL Database Browser, but not in my Objective-c iPad app (count = 
> 0).
> 
> select count(orderdata.order_id) from orderdata, custdata, orderinfo
>       where custdata.customer_id = orderinfo.cust_id and
>       orderdata.order_id = orderinfo.cust_id and
>       custdata.Bus_name = 'Albertsons'
> 
> I have also tried it this way using JOINs, but get the same results…
> 
> select count(orderdata.order_id) from orderdata
>       join custdata on custdata.customer_id = orderinfo.cust_id "
>       join orderinfo on orderdata.order_id = orderinfo.order_id "
>       where custdata.Bus_name = 'Albertsons'
> 
> Any ideas why?
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to