New topic: Ho to save a boolean?
<http://forums.realsoftware.com/viewtopic.php?t=47539> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message Markus Winter Post subject: Ho to save a boolean?Posted: Mon Apr 08, 2013 4:29 am Joined: Sun Feb 19, 2006 4:00 pm Posts: 1256 Location: Heidelberg, Germany Hi all, I'm having a mental block, but how do I save a boolean into a database? I have set up a column "Registered" as BOOLEAN in the database, and I use // db.SQLExecute("CREATE TABLE Products (Name varchar, Price double, InStock BOOLEAN)") db.sqlexecute ("Insert into Products (Name, Price, InStock) Values "_ +"( 'Mac', 999, '" + Str( ItemAvailable ) + "' )") but that seems wrong. If I save the boolean as a stringvalue then why do I bother setting up a boolean column? I'm obviously missing something here, and the LR is no help. TIA Markus Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- 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]
