Pcm kicker question
|
kevinho1993 |
Posted on 16-06-2008 16:19
|
Amateur
Posts: 22
Joined: 16-02-2008
PCM$: 200.00
|
One little question: how do you remove teams with Pcm Kicker? |
|
|
|
Addy291 |
Posted on 16-06-2008 16:23
|
Grand Tour Champion
Posts: 8915
Joined: 29-11-2006
PCM$: 200.00
|
Click on the grey box on the left of the team name and hit delete
You will also need to delete all the contracts of the cyclists in that team in DYN_contract_cyclist.
You will need to set all the cyclist's team to 61 in DYN_cyclist, that are in the team you deleted.
You will also need to change each of the cyclists fkIDexchange_cyclist to 0, of the cyclists that were in that team.
I think that's about it really.
Edited by Addy291 on 16-06-2008 16:24
YORKSHIRE BORN, YORKSHIRE BRED...
|
|
|
|
kevinho1993 |
Posted on 16-06-2008 16:26
|
Amateur
Posts: 22
Joined: 16-02-2008
PCM$: 200.00
|
Addy291 wrote:
Click on the grey box on the left of the team name and hit delete
You will also need to delete all the contracts of the cyclists in that team in DYN_contract_cyclist.
You will need to set all the cyclist's team to 61 in DYN_cyclist, that are in the team you deleted.
You will also need to change each of the cyclists fkIDexchange_cyclist to 0, of the cyclists that were in that team.
I think that's about it really.
Thank you? Nothing more? Someone else knows? |
|
|
|
Ad Bot |
Posted on 27-11-2024 22:57
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
IP: None |
|
|
Addy291 |
Posted on 16-06-2008 16:39
|
Grand Tour Champion
Posts: 8915
Joined: 29-11-2006
PCM$: 200.00
|
Also delete the lines corresponding to the deleted team in DYN_team_race
YORKSHIRE BORN, YORKSHIRE BRED...
|
|
|
|
kevinho1993 |
Posted on 22-06-2008 16:54
|
Amateur
Posts: 22
Joined: 16-02-2008
PCM$: 200.00
|
Addy291 wrote:
Also delete the lines corresponding to the deleted team in DYN_team_race
What do you mean with lines???? |
|
|
|
wanka84 |
Posted on 22-06-2008 17:01
|
Junior Rider
Posts: 35
Joined: 29-11-2006
PCM$: 200.00
|
if it's a db it's empty at the beginning, or you want to say to eliminate in the sta_race the number of the team in the gene_i_list_fkIDteam lines? |
|
|
|
kevinho1993 |
Posted on 22-06-2008 17:37
|
Amateur
Posts: 22
Joined: 16-02-2008
PCM$: 200.00
|
wanka84 wrote:
if it's a db it's empty at the beginning, or you want to say to eliminate in the sta_race the number of the team in the gene_i_list_fkIDteam lines?
It's for a database project |
|
|
|
wanka84 |
Posted on 22-06-2008 17:43
|
Junior Rider
Posts: 35
Joined: 29-11-2006
PCM$: 200.00
|
so you have to do also that
eliminate in the sta_race the number of the team in the gene_i_list_fkIDteam's lines
I'm not sure it's absolutely necessary but it's surely better |
|
|
|
kevinho1993 |
Posted on 22-06-2008 18:27
|
Amateur
Posts: 22
Joined: 16-02-2008
PCM$: 200.00
|
wanka84 wrote:
so you have to do also that
eliminate in the sta_race the number of the team in the gene_i_list_fkIDteam's lines
I'm not sure it's absolutely necessary but it's surely better
So the things i have to do are:
the things you posted + What addy posted?? |
|
|
|
wanka84 |
Posted on 22-06-2008 18:58
|
Junior Rider
Posts: 35
Joined: 29-11-2006
PCM$: 200.00
|
yes |
|
|
|
kevinho1993 |
Posted on 22-06-2008 19:06
|
Amateur
Posts: 22
Joined: 16-02-2008
PCM$: 200.00
|
wanka84 wrote:
yes
thanks |
|
|
|
kevinho1993 |
Posted on 23-06-2008 16:18
|
Amateur
Posts: 22
Joined: 16-02-2008
PCM$: 200.00
|
Addy291 wrote:
Click on the grey box on the left of the team name and hit delete
You will also need to delete all the contracts of the cyclists in that team in DYN_contract_cyclist.
You will need to set all the cyclist's team to 61 in DYN_cyclist, that are in the team you deleted.
You will also need to change each of the cyclists fkIDexchange_cyclist to 0, of the cyclists that were in that team.
I think that's about it really.
What's this? |
|
|
|
Addy291 |
Posted on 23-06-2008 16:51
|
Grand Tour Champion
Posts: 8915
Joined: 29-11-2006
PCM$: 200.00
|
https://www.pcmdaily.com/readarticle.p...icle_id=34
Look at the last screenshot. See the individual lines? at the far left of each line there is a grey box, click it and hit the delete button on you keyboard
YORKSHIRE BORN, YORKSHIRE BRED...
|
|
|