New topic: Database error 7046
<http://forums.realsoftware.com/viewtopic.php?t=30481> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message BillC Post subject: Database error 7046Posted: Wed Oct 14, 2009 1:14 pm Joined: Sun Nov 25, 2007 12:02 pm Posts: 31 Location: Orange County Ca I am loading a table from a flat file using a commit at the end of the loop because it takes so much time to do a commit after every entry. Somewhere in the data list, I sense there is a bad entry which gives the message: Database Error: 7046 Incomplete SQL Statement. Because there is no commit, I can't see now far along in the list it is. While doing the run, I am also writing to a ListBox but of course I can't see that either while the error is in effect. After OKing the error message it takes several seconds to finish which is why I suspect it is somewhere around the middle. The list is over 7000 entries. Is there some way to trap for the error and issue a commit as part of the error trap so I can find where in the list it is failing? Thanks, Bill 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]
