tanhk
Posts: 9
|
| Posted: 03/14/2004, 8:11 PM |
|
Hi
I have an editable grid with the following fields
ProjCode (PK)
ProjCategory (PK)
ProjNo (PK)
data1
data2
data3
data4
data5
I want to insert many records for the same ProjCode and
ProjCategory , in this case for every record I must key in
the ProjCode and ProjCategory on each row.
Is there any way to reduce the input of the ProjCode and ProjCategory just by key in once in the form and every record
that is inserted will used that values.
Thanks
|
 |
 |
DonB
|
| Posted: 03/15/2004, 6:53 AM |
|
You could utilize the Property panel's "Custom Insert" and/or "Custom
Update" to force a value into the field. It is usually not a good idea to
specify default values on the fields within the grid, because all rows of
the grid are updated when the Submit button is clicked. This might produce
undesirable results. But for your situation this might work OK if you do
that. All I can say is "try it".
--
DonB
http://www.gotodon.com/ccbth
"tanhk" <tanhk@forum.codecharge> wrote in message
news:240552d022f68d@news.codecharge.com...
> Hi
>
> I have an editable grid with the following fields
> ProjCode (PK)
> ProjCategory (PK)
> ProjNo (PK)
> data1
> data2
> data3
> data4
> data5
>
> I want to insert many records for the same ProjCode and
> ProjCategory , in this case for every record I must key in
> the ProjCode and ProjCategory on each row.
>
> Is there any way to reduce the input of the ProjCode and ProjCategory just
by key in once in the form and every record
> that is inserted will used that values.
>
> Thanks
>
>
>
>
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
tanhk
Posts: 9
|
| Posted: 03/15/2004, 7:41 AM |
|
DonB
Using a custom insert as mentioned by you will have a fix value for
the ProjCode & ProjCategory. This is not what I intended to do.
My intention was to for example have two textboxes, one for the ProjCode
and one for the ProjCategory. User will key in the value required once
and the editable grid will made use of these values for the insertion for each record.
Although I used custom table insert for the insertion and specific to use
the two control as input for the fields. The editable grid was unable to
get the data for the 2 textboxes.
Anything else I can try. Thanks
|
|
|
|
lneisius
Posts: 29
|
| Posted: 03/15/2004, 8:36 AM |
|
As I am somewhat new to dynamic sites using a database why would you require three primary keys?
|
|
|
|
DonB
|
| Posted: 03/15/2004, 1:18 PM |
|
Then it sounds like you will have to write some BeforeInsert code to call
the <dbconnection>.Execute() method and implement your own insert. You can
cancel the regular CCS insert operation from this event by setting the
InsertAllowed property to "false". This means when the event finishes, CCS
will not continue with its own insert operation.
--
DonB
http://www.gotodon.com/ccbth
"tanhk" <tanhk@forum.codecharge> wrote in message
news:24055ceabc54c9@news.codecharge.com...
> DonB
>
> Using a custom insert as mentioned by you will have a fix value for
> the ProjCode & ProjCategory. This is not what I intended to do.
>
> My intention was to for example have two textboxes, one for the ProjCode
> and one for the ProjCategory. User will key in the value required once
> and the editable grid will made use of these values for the insertion for
each record.
>
> Although I used custom table insert for the insertion and specific to use
> the two control as input for the fields. The editable grid was unable to
> get the data for the 2 textboxes.
>
> Anything else I can try. Thanks
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
