Albert, Thanks for the "heads up." That little change in the ID QUOTES in the database of origin fixed my issue. Thanks again, Ned
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Albert Berry Sent: Saturday, November 05, 2005 9:06 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: More correct feedback on Unable to delete tables Ned, check the IDQUOTE setting in the db and in the header for the table dump. If they disagree, you will get a syntax error because of the idquote character being taken as a literal. Ned Ritchie wrote: >More correct information to add: >I reinstalled my backup and it works ie. I can create & delete tables. >However when I create a new table by using a file created by UNLOAD like I >usually do the table is created with no visible errors, but then I cannot >delete ANY table without the Error in my first email shown below >My construction of my database has ground to a halt. >Please offer some suggestions. >Ned >=============================: > >Recently I've Unloaded some tables from another database and put them into >RRBYW10. > >Now I cannot delete any tables from RRBYW10 even ones quick one row ones >I've just created from scratch for testing. > >Neither will the DROP table work without the error. > >This does not appear to be the issue as I first thought: >(I had to stop the R:BASE process a couple of times when there was going to >be 27,000 lines of data I'd have to say O.K. to their failure. I'm assuming >the database was corrupted someway when I did that.) > >I can move onward from a backup, but I'd like to know more specifically what >one could do to determine what exactly happened and fix something like >that. Or does this just fall into the bucket of "not worth the effort?" > >When attempting to delete a table The error is: -ERROR- Syntax error (2367) > >Ned Ritchie > > > > >
