AndyW
|
| Posted: 07/10/2003, 8:38 AM |
|
WXP IE6.0 SQL2000 CCS2.1
I have editable grid with EAN and 2 serial numbers for each product. Once
the product is scanned fully with the document entering the warehouse I need
the simplified scanning procedure for document of leaving the warehouse.
The table consists of three numbers
EAN serial1 serial2
During second scan I would like to scan only serial1 and have the event to
fill EAN and serial2 based on serial1 on every row of editable grid.
I cant get it functioning as inserting rows for editable grid and CCS
specifics here is not to much documented.
I have tried to do something like following but i am getting errors.
Function Sloty1_DataSource_BeforeBuildInsert()
'Sloty1_DataSource_BeforeBuildInsert @67-07878D4A
..ParameterSources("ctrlserial2") = CCDLookUp("serial2", "Sloty", "serial1="
& .ParameterSources("ctrlserial1") , DBgwarek)
(it has to fill one control ctrlserial2 based on another ctrlserial1 if it
exist in the table before.)
Please try to give me some other samples of eventing editable grid which is
very interesting.
Cheers,
AndyW
|
|
|
 |
DonB
|
| Posted: 07/14/2003, 7:06 AM |
|
I think I'd use a Custom Update ( look in the Properties for the Grid
control). There you can put in additional UPDATE terms to SET the value of
the ctrlserial2 column with the value of the ctrlserial1 column of each
row). This has the advantage of not requiring the extra Dlookup - the
action takes place entirely on the database.
DonB
http://www.gotodon.com/cbth
"AndyW" <a.wisniewski@interia.pl> wrote in message
news:bek18t$tl7$1@news.codecharge.com...
> WXP IE6.0 SQL2000 CCS2.1
>
> I have editable grid with EAN and 2 serial numbers for each product. Once
> the product is scanned fully with the document entering the warehouse I
need
> the simplified scanning procedure for document of leaving the warehouse.
> The table consists of three numbers
> EAN serial1 serial2
> During second scan I would like to scan only serial1 and have the event to
> fill EAN and serial2 based on serial1 on every row of editable grid.
> I cant get it functioning as inserting rows for editable grid and CCS
> specifics here is not to much documented.
>
> I have tried to do something like following but i am getting errors.
> Function Sloty1_DataSource_BeforeBuildInsert()
> 'Sloty1_DataSource_BeforeBuildInsert @67-07878D4A
>
> .ParameterSources("ctrlserial2") = CCDLookUp("serial2", "Sloty",
"serial1="
> & .ParameterSources("ctrlserial1") , DBgwarek)
>
> (it has to fill one control ctrlserial2 based on another ctrlserial1 if it
> exist in the table before.)
>
> Please try to give me some other samples of eventing editable grid which
is
> very interesting.
>
> Cheers,
>
> AndyW
>
>
|
|
|
|
|
