>>>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.
If you want a database that can handle 2GB max, then ...
:)
If it's not broken, fix it until it is.
My Blog