Gossamer Forum
Home : Products : Others : MySQLMan :

editing a record

Quote Reply
editing a record
Hi,
in the demo some examples like matel have the option of "Edit" and "Delete" but others do not. Why? how can make my tables so that I can edit records?
thanks
Haris

Quote Reply
Re: editing a record In reply to
Hi Haris,

I ran into this problem myself. I fixed this by setting atleast one field "Primary", "Index", or "Unique."

This is needed in-order to edit. Please tell me if this works for you.

Robert Blackstone
Webmaster of Scato Search
http://www.scato.com
Quote Reply
Re: editing a record In reply to
You can only delete/edit records in browse/search only if there is a primary key defined in the table selected.

Cheers,

--
Gossamer Threads, Inc.
Quote Reply
Re: editing a record In reply to
Although I notice PHPmyadmin let's you edit records without primary keys. However, this is very misleading as if you have three fields with the same values, you'll end up updating all three columns, not just one (which is what the edit kind of implies).

Make sure your table has a primary/unique key as otherwise there is no way for the program to tell which record is which.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: editing a record In reply to
Thanks, setting the primary key seems to work.

Haris