databasePath:  dbpath: /Users/rolfmarsh/Library/Application Support/iPhone 
Simulator/5.1/Applications/361A7A76-FEAB-4E67-8F71-C1B291404BA5/Documents/r54.sdb

Regards,
Rolf


On Jun 3, 2012, at 6:07 AM, Black, Michael (IS) wrote:

> Not necessarily...you could have another copy with the same tables unless 
> you're creating this thing from scratch every time.  If you're opening an 
> exisiting database we've seen a number of people with similar problems who 
> found an "oops" and were opening another copy without data or different data.
> 
> 
> 
> Are you using an absolute or relative path name?
> 
> 
> 
> 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: Sunday, June 03, 2012 7:55 AM
> To: General Discussion of SQLite Database
> Subject: EXT :Re: [sqlite] Query runs in SQLite Database Browser but not in 
> iPad app
> 
> 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
> _______________________________________________
> 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