Thanks Clark Cox,
Now it is working fine.
I also need to retrieve all the values where this Boolean value is True.
I tried the  Query like both:
QuickLiteCursor * cursor = [db performQuery:[NSString stringWithFormat:
@"select * from Contact where UseDefault = 1 "]];
and
QuickLiteCursor * cursor = [db performQuery:[NSString stringWithFormat:
@"select * from Contact where UseDefault = YES"]];

But it is not working. How can I write the query for that ?

Thanks in advance
mahaboob

On 12/1/08 11:54 AM, "Clark Cox" <[EMAIL PROTECTED]> wrote:

> On Sun, Nov 30, 2008 at 9:29 PM, Mahaboob <[EMAIL PROTECTED]> wrote:
>> Hi,
>> I'm using QuickLite database to hold some data. I created one column as
>> Boolean to hold the state of a Checkbox and I inserted the values to the
>> table. But whenever I'm retrieving the values from database the Boolean
>> value is return only 1 and so I can't set the state of the Checkbox
>> correctly.
>> I used the code to set the Boolean value  to insert:
>> 
>> NSNumber *defValue;
>> if([cbUseDefault state] == NSOnState)
>>    defValue = [NSNumber numberWithBool:YES];
>> else
>>    defValue = [NSNumber numberWithBool:NO];
> 
> BTW, this can be simplified to:
> 
> NSNumber *defValue = [NSNumber numberWithBool: [cbUseDefault state] ==
> NSOnState];
> 
>> 
>> And for retrieving I used:
>> 
>> NSNumber * boolVal = [row valueForColumn:@"Contact.UseDefault"];
>>  if(boolVal>0)
>>    [cbUseDefault setState:NSOnState];
>>  else
>>    [cbUseDefault setState:NSOffState];
>> 
>> Where I got wrong? How can I solve this?
> 
> You want:
> 
> NSNumber *number = [row valueForColumn:@"Contact.UseDefault"];
> if([number boolValue])
>   [cbUseDefault setState:NSOnState];
> else
>   [cbUseDefault setState:NSOffState];


_______________________________________________

Cocoa-dev mailing list (Cocoa-dev@lists.apple.com)

Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com

Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/cocoa-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to