On Tue, 2006-02-07 at 22:38 -0500, THUFIR HAWAT wrote: > 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 :) >
You do realize that OOo will also interface with MySQL, PostgreSQL, Access and many other DBMS? Simply use the right driver. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
