Jennifer, It has worked in another situation because for whatever reason I believe you are being disconnected from your database. All it takes is a momentary glitch and you can be disconnected. There have been previous posts that have listed culprits as mundane as electric staplers connected on the same circuit. I was unaware that your main form was based on a temp table so my suggestion will not work.
Jan -----Original Message----- From: "Roberts, Jennifer" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 19 Feb 2010 12:42:05 -0500 Subject: [RBASE-L] - RE: Not Responding Hi Jan, I don’t believe this would work for me because my main form is based on a temp table list of clients. Users can click on a client from the list to edit/add information about that client. Since the list is a temp table it would go away when disconnected. I could modify the form so that there are buttons to connect, create and open their list but this seems like I would be adding another step for the users. Did you find that this has really reduced the not responding for you? Thank you, Jennifer Roberts Business Applications Specialist From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Friday, February 19, 2010 12:17 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Not Responding Jennifer, I now noticed that you are using the compiler. One thing that I have done is to mover your menu form externally - to an RFF. This does not require the database to be connected for the form to work. Then create a custom form action called ConnectDB that has all of your connect information to the datase. Then in all of your options you would place something like PROPERTY RBASE_FORM_ACTION ConnectDB ' ' the rest of my code here DISCONNECT This leaves the Menu form all by itself not connected to anything until needed. Creating the RFF from your existing mainmenu is easy. Just open your mainmenu form in the designer, CTRL A and then CTRL C to capture everything. Open up the external form designer and CTRL V to place everything in it. Save it as MSSCASEMGR.rff Your startup file would need to be changed to reflect the newform to something like REFF MSSCASEMGR.rff Jan -----Original Message----- From: "Roberts, Jennifer" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 19 Feb 2010 11:55:48 -0500 Subject: [RBASE-L] - RE: Not Responding Hi Buddy, Yes, the compiled executable resides in the same folder with the database. Thank you, Jennifer Roberts From: [email protected] [mailto:[email protected]] On Behalf Of Walker, Buddy Sent: Friday, February 19, 2010 11:48 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Not Responding Jennifer Is your database located in the same folder as your startup file. Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Roberts, Jennifer Sent: Friday, February 19, 2010 11:31 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Not Responding Well I seem to have gotten my I/O errors down but I am now having problems with the database not responding. This is a compiled executable with the RB1-RB4 files on a terminal server with the appropriate dll and config files. I am having the database go to not responding when I am the only user in the database. Anyone have any ideas what could be causing something like this. Here is my startup file: DISCONNECT SET SCRATCH TMP SET QUOTES=NULL SET QUOTES=' SET DELIMIT=NULL SET DELIMIT=',' SET LINEEND=NULL SET LINEEND='^' SET SEMI=NULL SET SEMI=';' SET PLUS=NULL SET PLUS='+' SET SINGLE=NULL SET SINGLE='_' SET MANY=NULL SET MANY='%' SET IDQUOTES=NULL SET IDQUOTES='`' SET CURRENCY '$' PREF 2 B DISCONNECT SET STATICDB OFF SET ROWLOCKS ON SET FASTLOCK OFF SET TIMEOUT 120 SET FEEDBACK OFF SET MULTI ON SET STATICDB ON SET QUALCOLS 2 SET FASTLOCK ON CLS CONNECT mss SET QUOTES=' SET DELIMIT=',' SET LINEEND='^' SET SEMI=';' SET PLUS='+' SET SINGLE='_' SET MANY='%' SET IDQUOTES='`' SET CURRENCY '$' PREF 2 B SET NULL ' ' SET DATE FORMAT MM/DD/YYYY SET DATE SEQUENCE MMDDYY SET DATE YEAR 30 SET DATE CENTURY 19 CLS EDIT USING MSSCASEMGR RETURN I am using RBASE 7.6 Build 7.6.8.30111. Ideas??? Suggestions of what else I can look for? I do not have any old dll or config files on the network, the shortcut has the –a in it… Thank you, Jennifer Roberts Business Applications Specialist Ohio Masonic Home This electronic message contains information from the Ohio Masonic Home, its operating subsidaiaries or affiliates. The information may be confidential, privileged or otherwise protected from disclosure. The information is intended to be received solely by [email protected], for use as designated in the message. If you are not the designated recipient, you are instructed not to review, disclose, copy, distribute orotherwise use of this transmission or its contents. If you have received this transmission in error, please notify the Ohio Masonic Home immediately at [email protected]; in addition, please delete your record of transmission. Sending, receiving, downloading, displaying, printing material that is harassing, fraudulent, offensive, intimidating, defamatory, or otherwise unlawful or inappropriate is strictly prohibited by The Ohio Masonic Home.
