nm
|
| Posted: 04/13/2005, 4:21 AM |
|
Hi
I am able to build one page with data from one table that I can update or insert to that table, but when I add a second table to I am not able to update or insert data into any table the submit button is not availble or the grid, when I dissable the update and insert I can see again the grid but not a submit button.
any directions on how to be able to insert or update data into two tables?
Thank you
|
|
|
 |
Nicole
Posts: 586
|
| Posted: 04/13/2005, 5:02 AM |
|
Hello,
When you’re using more than one table as Data Source for a Record or Editable grid forms you need to set up Custom Insert, Update and Delete
http://docs.codecharge.com/studio/html/index.html?http:...Insert.html?toc
http://docs.codecharge.com/studio/html/index.html?http:...Delete.html?toc
http://docs.codecharge.com/studio/html/index.html?http:...Update.html?toc
To make Custom Update and Delete for editable grid work properly the WHERE clause parameters should be configured in a special way. Usually you should include primary key in Where, e.g.:
Where primary_key_name = {primary_key_name}
So the parameters settings for {primary_key_name} parameter are like:
Field
Name: primary_key_name
Type: Integer
Condition: equals(=)
Parameter Source
Name: primary_key_name
Type: DataSource Column
_________________
Regards,
Nicole |
 |
|
nm
|
| Posted: 04/14/2005, 10:30 AM |
|
Hi Nicole
I have try to use the ex but in the custom insert parameter I am not able to see the "Type: DataSource Column"
what I am doing wrong
Thank you
|
|
|
|
Nicole
Posts: 586
|
| Posted: 04/15/2005, 1:46 AM |
|
Custom Insert doesn’t require WHERE settings. Only Custom Update and Delete.
_________________
Regards,
Nicole |
|
|
|
|
