Re: How to update table into database

I totally understand the use of a connection agent, in fact I have already created several actions in a connect definition (SELECT,UPDATE, INSERT). The problem is that when i retrieve data from database into a table, which action should i use? As mentioned in my previous post, I have retrieve 2 rows and placed them in a table (in a form) then I edited a column in the first row, then I added a new row (i now have 3 rows, and a row with an edited column)… If I use update, the newly added row does not get saved.