Adding a new record to a table RRS feed

  • Question

  • Hi Experts,
    How a new record will be added to a table useing rlock(),cursorsetprop(),tableupdate() etc.
    Please elaborate.

    Tuesday, November 24, 2009 3:06 AM


  • Forget rlock(), it has little use in VFP.

    A typical adding is:

    insert into myTable (field1, field2, field3) values (v1,v2,v3)

    this is same code with or without buffering. If buffered then the record would only be inserted in that table's buffer cursor with a negative recno(). If you tableupdate() it would get a new positive record number. 
    • Marked as answer by Tariq Iftikhar Tuesday, November 24, 2009 12:53 PM
    Tuesday, November 24, 2009 11:37 AM