On 2/1/06, G. Roderick Singleton <[EMAIL PROTECTED]> wrote: > On Tue, 2006-01-31 at 19:18 -0500, THUFIR HAWAT wrote: > > 1.) from Base, how does one create a compound primary key? > > 2.) In usenet there's a group, mailing.comp.open-office, which I > > thought was this group. Guess it's not, since posts to that group > > aren't showing up here. > > > > I've found that it's possible from SQL to do something like: > > > > PRIMARY KEY(student, course) > > > > but I'd like to do that from the "Base" GUI, not SQL, if possible. > > Must I use SQL to do that? > > > > When designing a table, Base only seems to allow one to select a > > single field, column, as primary key (?). Presumably the HSQLDB > > engine allows compound primary keys. > > > > > > I believe you were answered in [EMAIL PROTECTED] so check that > list, please. > -- > PLEASE KEEP MESSAGES ON THE LIST. > OpenOffice.org Documentation Co-Lead > http://documentation.openoffice.org/ > > Right, thanks. It's possible, but requires use either of SQL or something which looks like SQL. For that reason I decided to go with MySQL for the time being--but Base is a great project and I'll watch it with great interest :)
-Thufir --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
