Bubba
Posts: 33
|
| Posted: 10/18/2007, 5:33 PM |
|
Hi,
I am using CodeCharge 3.2.0.1
I am going crazy trying to get this to work and have tried 100 different things and still no joy! Maybe it is a bug?
Here is the issue.
I am using an editable grid builder.
I select some fields from 1 table (name, address, etc.) that pre-populate after the user has logged in – works fine.
I have then added some new text controls to the form that the user needs to fill in manually.
I have then set a custom insert to so that all the above said fields are appended to a different table.
Here comes the problem. I do not want to allow “update” – I just want to insert. It does not matter if there are duplicate entries to the new table.
If I have already got an entry in the table, and have selected “No” update for the form, then the page will not load properly – does not show grid (presumably because it wants to do an update as I already have an entry in the new table).
If I select “Yes” for update it will show the grid, however it will try and do an update, rather than an insert – so it over writes the existing entry, rather than appending a new entry.
I have tried a custom SQL sting, however I am not sure how to reference control values on the form for the insert statement.
Any advise would be greatly appreciated.
|
 |
 |
|
