udstx
Posts: 10
|
| Posted: 08/09/2012, 2:57 PM |
|
I have an Editable Grid that displays several (but not all) of the fields in a table. When I insert a new record, I need to set a couple of the non-displayed data field values to a value that is passed as a URL parameter. I can get the desired parameter but do not see how to modify the SQL INSERT statement. The passed parameter will be the same value for each record inserted with the SUBMIT button. It looks like I need to modify the statement with the 'Before Execute Insert'.
I tried working with 'Custom Insert' without success.
CCS 5.x
Windows 7-Pro
Mysql 5.x
Any help or directions??
|
 |
 |
DataDoIT
|
| Posted: 08/10/2012, 4:44 AM |
|
From the Editable Grid's Properties -> Data tab, choose Custom Insert
and build it there. One of your fields will have a parameter source
from the URL.
|
|
|
|
udstx
Posts: 10
|
| Posted: 08/10/2012, 6:58 AM |
|
SOLVED - The issue was that I was using the 'Custom Insert Type"=SQL and needed to use type TABLE
Thanks for the response
|
|
|
|
|
