Javier, My DB was due for a rebuild so I did that it the problem was cared for. However your code will be put away for another time. Thanks for the info.
James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Thursday, February 05, 2015 6:14 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: form will not delete When I get that type of results, most of the time it is a corrupted index. I have a utility in the Database Maintenance Menu that rebuilds the Indices; you can run it in a live environment. DIALOG 'Proceed with Packing Indices?' vYesNo vEndKey YES + CAPTION 'System Message...' ICON APP + OPTION Themename &vUser_theme IF vEndKey = '[Esc]' OR vYesNo = 'No' THEN GOTO Done ENDIF PAUSE 3 USING '>>> INDEX PACKING IN PROGRESS - DO NOT INTERRUPT <<<' PACK INDEX CLS PAUSE 1 USING 'Process Completed - Press any key to Continue' LABEL Done CLEAR VAR vEndKey, vYesNo RETURN ...or you can just run the command: PACK INDEX >From the R: prompt. Give it a try and hopefully it will solve your problem. As always, be sure to back up you database before packing the indices. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, February 05, 2015 4:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: form will not delete Bill, I tried that code and RBASE says the form does not exist. This is not surprising since I tried deleting it, RBASE acted like it deleted the form, but it is still there. I will try a rebuild tonight to see if that cares for the problem. Thanks for the suggestion. James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: Thursday, February 05, 2015 4:53 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: form will not delete Edit all fro sys_forms3 whe sys_form_name='formname' Bill Eyring -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, February 05, 2015 4:39 PM To: RBASE-L Mailing List Subject: [RBASE-L] - form will not delete Somehow a form got corrupted so that I cannot delete it. I tried bringing the same form into the DB with a backup copy but it shows two forms with the same name. Obviously the form has been corrupted. How can I get rid of the corrupted form? Will a rebuild do that? James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]]
