update only first row

[jefferson@results.com.br]

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,

[yvonne.milne]

Hi Jefferson,

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

Regards,

Yvonne

[jefferson@results.com.br]

Hi Yvonne,
No, RSP.
Regards,

[yvonne.milne]

Hi Jefferson,

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

Regards,

Yvonne