Ken - It almost sounds like you have a corrupted rule in that table or corruption in the database itself. Type LIST RULES FOR <youtablename> and see if there are any and if so, if they look to be correct.
If there is a rule, try dropping it and adding it back in. Otherwise, I'd UNLOAD/RELOAD the database and look for errors as you do that. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Tooker Sent: Thursday, July 27, 2006 1:24 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Syntax Error - 2367 Oma, Try your sample again, but I can enter the "WHE" once, but cannot change it. It will take the entry the first time say for example "WHE" but when for example you wanted to change it to"whe". Now I get the syntax error 2367. Again, thanks, Ken -- Reclaim Your Inbox and your sanity! For Mail Choose: http://www.mozilla.org/products/thunderbird/ For A Browser Choose: http://www.mozilla.org/products/firefox/ Get them, they work for you.... <>< = = = = = = = = = = = = K ~ V ~ T = = = = = = = = = = = = = = = ><> Ken Tooker wrote: > Oma, > > Thanks for the response. And I figured it had to be something that is > here local in my office as well at my customers site. > > But, I did create a new database not using a full blown database one > from a fresh start using Version 7.1. Also, with the same names that > you had. "test" for the database name and "test" for the table. > However, in real life and offsite, the names are different. It > appears that this did not matter. But, (here I go with my buts) the > table that I created I did was within the same directory as my problem > database. > > Proceed on, I just created a new directory, nothing else in it, then > created a new database. Like you found, the problem is *_not_* > there. It has something to do with the original database I have to > assume. Now what to look for is another treasure hunt. I > persevere... :-[ > > Thanks, I will keep you posted.. > > Ken >
