At 03:39 PM 5/2/2009, Richard Croy wrote:
I don't know exactly what was going on, but I now need to remember to
say "No" whenever R:Base asks if I want to insert a null row in a new
table.
Maybe this inquiry message needs a little "tweaking". Or elimination.
Hello Dick,
You may need to re-visit specific constraints related to this table.
After successfully CONNecting the database, try the following commands
at the R> Prompt to identify constraints for that specific table:
LIST CONSTRAINTS FOR tablename
LIST PKEYS FOR tablename
LIST FKEYS FOR tablename
LIST RULES FOR tablename
Last but not least, make a backup copy of your working database and
then try to re-build the entire database using UNLOAD ALL command
and see how healthy your database really is.
For complete details and step-by-step instructions, take a look at
the following article at From The Edge:
From The Edge: http://www.razzak.com/fte/
Article: Database Maintenance (R:BASE 7.6 for Windows)
Date Posted: 12/29/2008
Hope that helps to keep everything in order!
Good Luck and Very Best R:egards,
Razzak.
