I would like to update an existing database - is there a way of doing a database.updateRow(row as databaseRow)? Without reverting to SQL code.
It appears you can only AddRow a DatabaseRow, not update one.
I recommend using an ORM created by actual experts because you can interact with the rows as objects exactly as you’ve asked to do.
ActiveRecord - the ORM
ARGen - Code, class, and project generator
2 Likes
Check the documentation on RowSet.EditRow. It, and the RowSet.SaveRow should be able to update the row.
1 Like
Well today I learned…
I’d still recommend an ORM if that’s the way you wish to interact with your database.
Of course, I didn’t think of looking at rowset.
However, I found another way around the problem.
The ORM sounds a good idea but they too have a learning/implementation curve and sometimes unexpected limitations so SQL is a quicker go-to.