Updating a specific cell in a SQL database

microsoft.public.dotnet.languages.vb

11 Jul 2006 1:47 PM

zoneal

Here's what's happening. I need to take a value, and insert it into an
already-created row in a SQL database. The methods I know of only add
rows to the end, therefore I cannot edit information. If I know the
index for the row to be edited, how can it be done? Help would be much
appreciated.

11 Jul 2006 1:54 PM

Andrew Morton

zon***@yahoo.com wrote:

> Here's what's happening. I need to take a value, and insert it into an
> already-created row in a SQL database. The methods I know of only add
> rows to the end, therefore I cannot edit information. If I know the
> index for the row to be edited, how can it be done? Help would be much
> appreciated.

I think you'd be better off asking in an SQL-related newsgroup. However,
you're looking for the UPDATE command, for example

UPDATE authors
SET state = 'PC', city = 'Bay City'
WHERE state = 'CA' AND city = 'Oakland'

Andrew