No. Only one thread, only one user. The database is in the same directory as the application, both on my PC.
I am beginning to think that perhaps the database has somehow become corrupted. That might explain both the original problem (not adding records in the compiled version) and the new one (the error with the SQLSelect in the IDE). I have renamed the datbase file and rerun the program, which creates a new database. I am not getting the error with it. I may have to rebuild my database from old records. (several expletives deleted!) Paul Dobbs Software Engineer, Staff Lockheed Martin Missiles and Fire Control Phone (972) 603-1244 Fax (972) 603-2017 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Bambini Sent: Wednesday, September 06, 2006 11:35 AM To: REALbasic NUG Subject: Re: Database problem Are you sharing the same db instance within multiple threads? --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ On Sep 6, 2006, at 6:22 PM, Dobbs, Paul wrote: > I added > > If Not DB.Connect Then > MsgBox "DB not connected" > End If > > before > > RS = DB.SQLSelect("Select fname, lname, empno from people where > active = 'true' order by lname, fname") > > and (1) I don't get the message box and (2) I still get the same > error. > > Paul Dobbs > Software Engineer, Staff > Lockheed Martin Missiles and Fire Control Phone (972) 603-1244 Fax > (972) 603-2017 _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
