New topic: 

rb 2009 r5 handles boolean fields differently

<http://forums.realsoftware.com/viewtopic.php?t=31429>

       Page 1 of 1
   [ 3 posts ]                 Previous topic | Next topic         Author  
Message       dplaut           Post subject: rb 2009 r5 handles boolean fields 
differentlyPosted: Sat Dec 05, 2009 8:33 pm                        
Joined: Mon Jun 23, 2008 3:04 pm
Posts: 58              Heads up... This worked in all RB versions up thru 2009 
r4:
select MyField from MyTable where MyBooleanField = 1

MyField was created as a boolean.

Now with 2009 r5 I have to do this:
select MyField from MyTable where MyBooleanField = 'True'      

    Last edited by dplaut on Sat Dec 05, 2009 9:17 pm, edited 1 time in total.  
 
                            Top                npalardy           Post subject: 
Re: rb 2005 r5 handles boolean fields differentlyPosted: Sat Dec 05, 2009 9:10 
pm                        
Joined: Sat Dec 24, 2005 8:18 pm
Posts: 5461
Location: Canada, Alberta, Near Red Deer              It's a completely 
different database engine since ... about 2005 ish     
_________________
My web site Great White Software
RBLibrary.com REALbasic learning  
                            Top               dplaut           Post subject: 
Re: rb 2009 r5 handles boolean fields differentlyPosted: Sat Dec 05, 2009 9:24 
pm                        
Joined: Mon Jun 23, 2008 3:04 pm
Posts: 58              Sorry, I meant "2009" not "2005." I have corrected my 
post.

I also see that lots of other valuse are not being saved correctly. I'm aware 
that RealSoftware is working on a patch to rb 2009 r5. Quite frankly, for all 
the debugging I've had to do before I realized RB was messing up the data I 
think 2009 r5 should be totally recalled.

http://www.realsoftwareblog.com/2009/12 ... oming.html   
                            Top            Display posts from previous: All 
posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost 
timeSubject AscendingDescending          Page 1 of 1
   [ 3 posts ]     
-- 
Over 1500 classes with 29000 functions in one REALbasic plug-in collection. 
The Monkeybread Software Realbasic Plugin v9.3. 
http://www.monkeybreadsoftware.de/realbasic/plugins.shtml

[email protected]

Reply via email to