Jennifer Count the records in the driving table like this.
SET VAR vrows INTEGER = 0 SEL COUNT(*) INTO vrows INDIC ivrows FROM drivingtable WHERE LIMIT = 1 IF vrows = 0 THEN ENTER USING trackeredit ELSE EDIT USING mainform ENDIF Buddy ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Roberts, Jennifer Sent: Tuesday, July 01, 2008 8:24 AM To: RBASE-L Mailing List Subject: [RBASE-L] - New Database, no records, error handling Is there a way to handle the following? I have created a new database, however when I place it out for the users, until they start putting information in it, there will be no records. The main form would normally pull up a list of records and gives the user a choice of editing one of those records, or adding a new one. So I need to do some sort of error handling so that when the user pulls up the main form, if it returns no records that it will give the user the form to enter a new record. I have set the following in the on before start EEP: SET ERROR VARIABLE errvar IF errvar <> 0 THEN ENTER USING trackeredit ENDIF However that is not working. Any suggestions would be greatly appreciated. Thank you, Jennifer Roberts Business Applications Specialist Ohio Masonic Home 937.525.3080 x5788 This electronic message contains information from The Ohio Masonic Home, its operating subsidiaries 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 or otherwise 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.
