Skip to Content

Are Business One Recordsets constantly connected in the database?

BOne 8.82

So if I set a value in a recordset to a value such as

oRecordSet.Fields.Item("myDateColumn").Value = Date.Today

will it automatically update on the row that the recordset is on like in an adodb connection?

Thank you for your assistance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 17 at 05:18 AM

    Hi Derek,

    The Recordset object is a browsing tool only. You will need to use other objects (interfaces) to update data into the company database, if that is what you mean.

    If you mean update data in the recordset itself, then yes, it will update the row that you are on. You can take a look at the documentation on how to navigate a Recordset.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded