myLittleTools Community Forum
»
myLittleAdmin For SQL Server (2005, 2008, 2012)
»
Support Queries
»
can't edit record in table
|
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
|
|
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.
|
|
Guest |
myLittleTools Community Forum
»
myLittleAdmin For SQL Server (2005, 2008, 2012)
»
Support Queries
»
can't edit record in table
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 :
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.