update only first row

Hi,

How I can update only first row on table?
I try use subquery but is not supported.
///
update conversas set agente=username() where conversa_id in(select conversa_id from conversas where empty(agente) limit 1)
///

Regards,

Hi Jefferson,

Where are you calling the update from? Is this an ODBC connection?

Regards,

Yvonne

Hi Yvonne,
No, RSP.
Regards,

Hi Jefferson,

Query for the recno() and then update where that recno().

Regards,

Yvonne