Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - DBA (base de données)
DBA (base de données)
 
   NeoOffice Forum Index -> OpenOffice.org MacOS X X11 Support
View previous topic :: View next topic  
Author Message
buzhug35
Guest





PostPosted: Tue Mar 15, 2005 3:10 am    Post subject: DBA (base de données)

Hello,
I've just installed OpenOffice on my Mac.
I want to create a primary key on a table that is already created and I can't manage to do that.
I want to create relations between two tables : I can add one table to the request but I can't add another one to create the relation.
The explanations of the help menu don't work.
Thanks a lot for helping me
Sad
Back to top
fabrizio venerandi
Guest





PostPosted: Tue Mar 15, 2005 1:59 pm    Post subject:

what database are you using?
Back to top
OPENSTEP
The One
The One


Joined: May 25, 2003
Posts: 4752
Location: Santa Barbara, CA

PostPosted: Tue Mar 15, 2005 9:11 pm    Post subject:

Note that if you're using MySQL (just a stab in the dark) you need to create the root databases from the MySQL client. If you've created the root database, you should be able to create new tables. At least this is the way it is in 2.0 betas on other platforms and probably will be for final...it's entirely possible that this doesn't extrapolate to 1.1 and you may need to create the tables in the MySQL client as well.

ed
Back to top
buzhug35
Blue Pill


Joined: Mar 15, 2005
Posts: 2

PostPosted: Sat Mar 19, 2005 6:35 am    Post subject: Database (base de données)

Hello,
Because I can't manage to reach my Mysql base (the port seems to be false), I use CALC spreadsheets to create table. I also try to create a new table from nothing. The same problem occurs : how can I do to put a primary key on one field ? I think that without a primary key, I couldn't manage to create relations between tables. I manage easily to do that with Access (that I discoverd after Open Office) ; I was sure that Openoffice was able to do the same thing. Is anyone who can help me ? (I'm not good in english spoken).
Thanks
Back to top
kiwi
Captain


Joined: Mar 30, 2004
Posts: 51

PostPosted: Mon Apr 04, 2005 12:01 am    Post subject:

I'm just going to reply in French (yes I am showing off Very Happy )

J'utilise OOo Mac pour acceder à des bases de données PostgreSQL depuis quelque temps. OOo n'est pas le bon outil pour créer des bases relationneles (Access non plus d'ailleurs) mais est parfait pour acceder aux données et les mettre en form.

I faut mieux utiliser un outil spécifique pour créer les tables - j'utilise pgaccess pour créer mes bases PostgreSQL par exemple

Tony
Back to top
buzhug35
Blue Pill


Joined: Mar 15, 2005
Posts: 2

PostPosted: Mon Apr 04, 2005 2:20 pm    Post subject: et avec Mysql

Bonsoir et merci pour la réponse (je continue en français parce que mon anglais n'est pas très riche)
En fait à l'origine je voulais récupérer des bases de données que j'avais créées en Mysql et remplies par une interface PHP en local. Je voulais passer à une solution facilement exportable.
Je vais poursuivre mes investigations du côté de ce que vous proposez.
Cordialement
CLB
Back to top
Guest






PostPosted: Fri Jun 10, 2005 4:57 am    Post subject: Re: et avec Mysql

Sorry, I'm going to qualify one of my statements here, because it is misleading. You can edit dBase files directly through the form or grid table database interface, but not Calc files.


Alex
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> OpenOffice.org MacOS X X11 Support All times are GMT - 7 Hours
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.