On Fri, 2006-02-24 at 11:17 -0700, Bud wrote: > I created a Data Base but for the life of me I can't Edit it. > The "Help" does not explain it or I just don't understand. > I am a simple guy and I need a simple explanation on how to edit the > Data Base. Or maybe it just can't be done.
This is a FAQ. Answer: You need to make at least one of your table columns a primary key. The reasoning is that any update needs to be able to uniquely identify which row to change. There is at least one database system which inserts silent object identifiers (OIDs) and thus allows updates without a primary key (but not via Base I believe). AFAIK PostgreSQL is the only system that does it. However, later versions are making it optional (with default being not to insert OIDs). If, indeed, Base doesn't insist on a primary key during table design (for the built-in HSQL engine database at least), then that may make a worthy enhancement request. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
