PCM.daily banner
21-12-2024 13:20
PCM.daily
Users Online
· Guests Online: 21

· Members Online: 0

· Total Members: 162,190
· Newest Member: Jameson01
View Thread
PCM.daily » Pro Cycling Manager 2023 » PCM23: Technical Issues
 Print Thread
Problems with my database
Vincenzo Nibali
Hello, can anyone explain to me how to solve this problem?
i.ibb.co/SV8ypGR/Uden-titel.png
 
cunego59
This looks like there's an entry in the DYN_sponsor_results table (potentially in row 5, I'm not super familiar with Fast Editor notation) that has an erroneous fkIDcyclist number, specifically -1. The easiest way to fix this would likely be to remove the entry entirely. If you know which rider should be in that entry, you can also try and replace the -1 with that cyclist's ID from DYN_cyclist.
 
Vincenzo Nibali
cunego59 wrote:

This looks like there's an entry in the DYN_sponsor_results table (potentially in row 5, I'm not super familiar with Fast Editor notation) that has an erroneous fkIDcyclist number, specifically -1. The easiest way to fix this would likely be to remove the entry entirely. If you know which rider should be in that entry, you can also try and replace the -1 with that cyclist's ID from DYN_cyclist.


Ok thanks I will try.
Is there another edit program you can recommend
 
cunego59
Let me know if it works!

I use the Excel Editor for the most part. It doesn't have the nice interface that the Fast Editor has, so for smaller changes it might not be the best way to go and it may take some getting used to. But if you want to edit larger sets of data, working in Excel is quite useful.
 
Jump to Forum:
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Oscar Freire
Oscar Freire
PCM10: General Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 18,676 PCM$
bullet df_Trek 17,674 PCM$
bullet Marcovdw 15,745 PCM$
bullet jseadog1 13,752 PCM$
bullet baseba... 10,539 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 21,990 PCM$
bullet df_Trek 15,820 PCM$
bullet Marcovdw 15,200 PCM$
bullet jseadog1 13,700 PCM$
bullet baseball... 7,432 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 0.19 seconds