>>>>Hi All -
>>>>
>>>>I need to update a specific row within a table something like this:
>>>>
>>>>UPDATE mytable SET myfield = 10 WHERE (ROWNUMBER = 4)
>>>>
>>>>but I can't find a good way to identify the row. I've looked at ROW_NUMBER(), IDENTITY(), and RANK(), but none of them seem to fit. Could someone explain how to do this?
>>>>
>>>>Thanks
>>>
>>>You need a key somehow. This isn't VFP. What are the field values that make your 4th row unique? Make them the where clause.
>>
>>Thanks William.
>>My table has a fixed number of rows so I just added another column with rownumber. It seems to work OK. I was just hoping to make it a little simpler with a function like RecordNo().
>>
>>Thanks for the clarification.
>>
>>And now my mantra "Why 'O Why can't MS make SQLServer/NET as easy as VFP?" They should get Calvin and Levy on the team.
>
>youre supposed to update on primary key.....
Doesn't work here. The table is constructed entirely in code cell by cell. There is no PK. In effect the 'rank' column I added becomes the primary key.