In article <[email protected]>, Ian Whitfield wrote: > Thanks Mark > > I think you are right!! I DON'T see a Primary Key!! (I'm sure I DID set it!!) > BUT - If I try to set it in Base it does not accept the setting. > > If I try in MyAdmin to set my first column (RecordID) as Primary I get the > error > "#1062 - Duplicate entry '' for key 'PRIMARY' " > > I can not "see" any Primary Key in the list of fields > So I ran .. > > SELECT EXISTS( > SELECT 1 > FROM information_schema.columns > WHERE table_schema = 'FedSaintsNew' > and table_name='TABLE 2' > and column_key = 'PRI' > ) As HasPrimaryKey > > I get "HasPrimaryKey 0" > > What is stopping me setting the key or how do I get round this??!!
Hi Ian, Are you saying that phpMyAdmin doesn't show a primary key? But won't let you enter one? That sounds very odd. Personally I would do most of the setup in phpMyAdmin rather than Base. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
