Normal Topic Retrieving a boolean element from another file (Read 597 times)
NHUser
Full Member
***
Offline



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
Retrieving a boolean element from another file
Nov 14th, 2014 at 4:03pm
Print Post Print Post  
I'm having an interesting problem.  I'm mass updating an element in a number of record.  I am using @LookupSourceList() to get a bunch of info.  It was working fine until I tried to retrieve a boolean element.

The boolean element is formatted to read Yes or No in the record of the original.  I'm getting the info OK but sometimes I get a "1" and sometimes I get a "ÿ" from the other file.  Both of the files in question have "Yes" in the element of the original file.

The element in the file that is being updated is not boolean.  Is that the problem?  If not, what else is going on?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Retrieving a boolean element from another file
Reply #1 - Nov 14th, 2014 at 4:27pm
Print Post Print Post  
ÿ can occur when -1 is converted to a character. -1 being the unset value of a boolean field.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged