Negative Value in Boolean field

[Barry]

Hi

I have a field of type Boolean (lets name it X), in Access, but i need to
insert -1, not true or false to display a checkbox as unchecked, since the
app is developed in VBA, i could find out from the code that it get values
of 3 fields and field X must be -1 to display the checkbox as unchecked.

How do i insert -1 in a DataRow Object
row.X = -1

TIA
Barry

 

[sloan]

You need to use

=0 (false)
or
<>0 (true)

for your true/false checks.

Do not use =1 or =-1

 

[PvdG42]

Hi

I have a field of type Boolean (lets name it X), in Access, but i need to
insert -1, not true or false to display a checkbox as unchecked, since the
app is developed in VBA, i could find out from the code that it get values
of 3 fields and field X must be -1 to display the checkbox as unchecked.

How do i insert -1 in a DataRow Object
row.X = -1

TIA
Barry

Barry,
If your question is related to MS Access, as it appears to be, you'll have
much better response if you ask in an Access group.
There are several Access groups available, among which are:

microsoft.public.access

microsoft.public.access.modulesdaovba

 

[Barry]

Thanks for your reply. I need to insert the value in a Access Database but
using a application developed in C#, hence the posting on this forum. i have
also posted other questions in this regard here itself.

 

[Barry]

Thanks for your reply, unfortunately i MUST insert -1 in the field, i have
found the answer

row.X = Convert.ToBoolean(-1);

 

[jacerhea]

Thanks for your reply, unfortunately i MUST insert -1 in the field, i have

found the answer

row.X = Convert.ToBoolean(-1);

I'm glad that worked for you, but Convert.ToBoolean is going to return
a Boolean data type with a value of true or false, not a signed int.

-1 is NOT being assigned to the field row.x. Its being cast to a data
type of Boolean. http://msdn.microsoft.com/en-us/library/h0b8dwce.aspx

 

[Barry]

what you say could be right, but for me what matters is that it works and
get the job done, some of the work is time-bound and i cannot afford to
search for what is theortically correct

 

[PvdG42]

Thanks for your reply, unfortunately i MUST insert -1 in the field, i have
found the answer

row.X = Convert.ToBoolean(-1);

I hope you don't ever have to check that field for a value of -1, because it
won't be there:

bool t;
t = Convert.ToBoolean(-1);
int i = Convert.ToInt32(t);
Console.WriteLine("T = {0}, and I = {1}", t.ToString(),
i.ToString());

yields: T = true and I = 1 (not -1)

 

[Barry]

What you have written maybe right.

But you could try inserting in a Access database table which has type
Yes/No a value of -1 and it shows up in the table

Try inserting the value using C# code not directly in the Table through
Access