myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

can't edit record in table Options · View
gregart
Posted: Thursday, August 02, 2007 9:43:31 PM
Rank: Newbie
Groups: Member

Joined: 8/2/2007
Posts: 1
Points: 0
Location: ontario
I saw an earlier post where the person couldn't edit a record in a table - the response was to press the edit button at the start of the record. I do not see an edit button at the start of the record. My web host provides myLittleAdmin as a tool to access the database - perhaps the edit capability is not provided due to it being hosted by a web hosting firm? If I can't edit it this way is there a way to write an update query and run it to update the field I want to in the record?

thanks
gregart
elian
Posted: Saturday, August 04, 2007 1:19:01 PM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
It looks like your table does not have any primary key.
Add a primary key to your table (table/keys/primary key) and the edit icon will then appear.
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.