Re: [libreoffice-users] Base stuck in Read Only mode??

In article <5152BFD4.7050405@telkomsa.net>, 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: users+help@global.libreoffice.org
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