This topic contains 6 replies, has 0 voices, and was last updated by Anonymous 8 years ago.
- June 21, 2011 at 3:57 am #785
I was having problem updating a table. My current table has two rows, one row was edited then I added another row. How do I update the table into the database (updating the edited row and inserting the newly added row)?June 21, 2011 at 4:48 pm #5771
The Connection Agent is required to integrate with an outside database table. Please refer to the documentation regarding the Connection Agent: http://www.perfectforms.com/Documentation/manual/html/?lookup_agent.htmJune 22, 2011 at 1:48 am #5772
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.June 22, 2011 at 8:53 pm #5776
Are you using the column – All rows in your send parameter?June 23, 2011 at 11:57 am #5780
yes sir… am using “All rows” in the send parameter…
have you tried the example given?June 23, 2011 at 11:22 pm #5782June 27, 2011 at 1:47 am #5786
should i be using insert? Do I have to do a loop on all the rows to check if the row is newly added (for insert) or if the row is existing already (for update) when saving? what about rows which are deleted?
You must be logged in to reply to this topic.