Results 1 to 4 of 4

Thread: update only first row

  1. #1
    Member
    Join Date
    Feb 2012
    Location
    So Paulo - Brasil
    Posts
    74

    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,

  2. #2
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,746
    Hi Jefferson,

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

    Regards,

    Yvonne

  3. #3
    Member
    Join Date
    Feb 2012
    Location
    So Paulo - Brasil
    Posts
    74
    Hi Yvonne,
    No, RSP.
    Regards,

  4. #4
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,746
    Hi Jefferson,

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

    Regards,

    Yvonne

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us