I want to Browse data from SQL table / or View in a form table and get access to it (add/update/delete)
(current Lookup Rules for Forms V.9.1 can fill fields without adding new rows for each retrieved rows from Database)..
I want to Browse data from SQL table / or View in a form table and get access to it (add/update/delete)
(current Lookup Rules for Forms V.9.1 can fill fields without adding new rows for each retrieved rows from Database)..
In Forms 10 you can retrieve table row values from SQL and populate table rows in a form and then add additional rows to the table in Forms. If you want to add the additional rows that are entered into the form into your SQL database table, then you simply just need to kick off a Workflow that would do that.
I have problem with that too.
i have tried to fill form table by sql table rows by using invoke business process tool in a workflow but it failed it only insert first row in a form table.
please can you help me with this.
Any luck with this? I am at the same spot.