New topic: Orders Database fails to recreate
<http://forums.realsoftware.com/viewtopic.php?t=43868> Page 1 of 1 [ 2 posts ] Previous topic | Next topic AuthorMessagehgibbons4 Post subject: Orders Database fails to recreatePosted: Thu May 03, 2012 4:24 pm Joined: Wed Apr 25, 2012 11:23 am Posts: 1 I'm a RealBasic newbie, working through the Orders example database, which generates the database dynamically, in code, if the Orders.rsd file is absent. However, when I delete the populated database (Orders.rsd) in order to force the program to regenerate the database, all I get is the following for the .rsd file: SQLite format 3@ -â çsAAotable__REAL__SQL__TEMP__TABLE____REAL__SQL__TEMP__TABLE__CREATE TABLE __REAL__SQL__TEMP__TABLE__ (a, b, c) In other words, OrdersDB.CreateDatabaseFile works without error, but the subsequent SQLExecute statements that are supposed to create the tables produce nothing and fail without any error message. What could be missing here? I'm on a MacBookPro running Snow Leopard. There's another question about this database code that baffles me: I can find nowhere code that populates the SearchBy and SearchOption PopupMenus. Thanks in advance for your help. I'm still on the steep side of this learning curve. hgibbons4 Top timhare Post subject: Re: Orders Database fails to recreatePosted: Thu May 03, 2012 7:41 pm Joined: Fri Jan 06, 2006 3:21 pm Posts: 11261 Location: Portland, OR USA I'm not very familiar with the example, but it is now necessary to call Database.Commit after table creation commands. Make sure the example is calling Commit after it creates the tables. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 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]
