Hot Topic (More than 10 Replies) Boolean Field (Read 2313 times)
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Boolean Field
Jul 19th, 2005 at 11:12pm
Print Post Print Post  
I have a boolean LE that I cleared with "Clear(Reconcile)". That actually did clear the LE, but after saving the record, I discovered that the LE contained this character: "ÿ".

I discovered this because I am using @IsBlank(Reconcile) as conditional programming, and it worked fine after clearing the Reconcile LE until the record got saved to disk. After that, programming found that the LE was not empty anymore, and my programming did not execute that portion of code. (I was able to see this character after changing the field type to TEXT.)

Is it proper behaviour for a cleared boolean LE/field to contain that character after saving the record?

I can work around this by leaving the field set to TEXT, but I wanted to know if this is normal.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Boolean Field
Reply #1 - Jul 20th, 2005 at 1:44pm
Print Post Print Post  
Good Morning Carl,

I'll have a look into it and see what I can discover.

What type of element were you using a check box, a text box, or something else?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Boolean Field
Reply #2 - Jul 20th, 2005 at 2:05pm
Print Post Print Post  
Ray,

It is a simple text box that was bound to a boolean type field. (I have since changed the field type to text, in order to get my programming to function the way I want.)
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Boolean Field
Reply #3 - Jul 22nd, 2005 at 10:43pm
Print Post Print Post  
Ray,

Have you found out anything about this topic?

I've been thinking that Sesame's Boolean text fields were "tri-state" like a check box. But after checking the manuals, I notice that they only mention tri-state in reference to check boxes.

I just did a little testing, and it does appear that only check boxes have this ability. Was that the plan?

It would seem to me that since both types of layout elements use a Boolean field to store their values, that they would both behave in a similar manner when queried by @IsBlank(). And if the field for a check box can be blank, that must mean that it can be blank for a Yes/No text box as well. Is that correct logic, or am I going down the wrong road here?

Like I mentioned in an ealier post, I solved my problem with this topic simply by changing the field type to text. I just wanted to know if this is something that I should report for the sake of making sure Sesame is funtioning as the development team intended.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Boolean Field
Reply #4 - Jul 23rd, 2005 at 12:50pm
Print Post Print Post  
Carl,
A boolean field is tri-state so as to be able to hold the values coming out of a tri-state checkbox. A boolean field is a numeric (a single byte) with any of three values: 1, 0, or -1.

1 = true
0 = false
-1 = undetermined

If you use an straight text output format, a numeric -1 translates into "ÿ". That is because in ASCII it is unsigned and a byte long unsigned -1 is 255 - which is "ÿ" in the ASCII table most of us use (ISO-8859-15 latin).

The bug, is that @IsClear, is not seeing that as a "clear" value.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: Boolean Field
Reply #5 - Jul 23rd, 2005 at 3:29pm
Print Post Print Post  
Quote:
The bug, is that @IsClear, is not seeing that as a "clear" value.


@IsClear the same as @IsBlank?

Thanks
  

Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Boolean Field
Reply #6 - Jul 23rd, 2005 at 5:28pm
Print Post Print Post  
Mark,

Thanks for explaining this.

I assume, as Bob does, that you meant @IsBlank.

I just ran some more test with that information. I don't have time now to document the results right now, but I'll try to later tonight or tomorrow.


  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Boolean Field
Reply #7 - Jul 24th, 2005 at 1:50pm
Print Post Print Post  
Robert asked:
Quote:
@IsClear the same as @IsBlank?

Yes. Sorry for the confusion.

Carl stated:
Quote:
I don't have time now to document the results right now

No need. Its has already been written up and is in my in-box.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
Re: Boolean Field
Reply #8 - Jun 6th, 2006 at 8:55pm
Print Post Print Post  
Is there a way to get it to show the check mark again instead of the "ÿ"?
  
Back to top
 
IP Logged
 
Ben
Lantica Support
*****
Offline



Posts: 218
Joined: Apr 7th, 2005
Re: Boolean Field
Reply #9 - Jun 7th, 2006 at 3:14pm
Print Post Print Post  
Hello CapitalG,

Is your element a checkbox, or a text element bound to a boolean field?

-Ben
  
Back to top
IP Logged
 
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
Re: Boolean Field
Reply #10 - Jun 7th, 2006 at 5:10pm
Print Post Print Post  
Checkbox
  
Back to top
 
IP Logged
 
Ben
Lantica Support
*****
Offline



Posts: 218
Joined: Apr 7th, 2005
Re: Boolean Field
Reply #11 - Jun 7th, 2006 at 8:26pm
Print Post Print Post  
CapitalG,

Normally a checkbox will not display the "ÿ" character.
Are you seeing the character in tableview, or on the form?

-Ben
  
Back to top
IP Logged
 
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
Re: Boolean Field
Reply #12 - Jun 7th, 2006 at 9:13pm
Print Post Print Post  
On the form.  I thought maybe my database had a problem so I opened up the sample customer database and the checkbox in that database has it also.  Mine actually has a U with the dots above it. Sad
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Boolean Field
Reply #13 - Jun 7th, 2006 at 11:21pm
Print Post Print Post  
If you are on Windows it is likely that you do not have the "Wingdings" font installed. If you are on Linux, you are probably missing the "zapf dingbats" font. If you are certain that you have the appropriate font for your system, there is likely some reason that Sesame cannot get to, or use, that font.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
Re: Boolean Field
Reply #14 - Jun 8th, 2006 at 4:54pm
Print Post Print Post  
Thank you! 

I don't know how I lost my Wingding but I did. 

Works great.

Smiley

  
Back to top
 
IP Logged