PCM.daily banner
02-04-2025 13:52
PCM.daily
Users Online
· Guests Online: 28

· Members Online: 0

· Total Members: 163,792
· Newest Member: mangalbhanu
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
RSLT dominating
RSLT dominating
PCM11: Beautiful Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 20,276 PCM$
bullet df_Trek 18,974 PCM$
bullet Marcovdw 17,345 PCM$
bullet jseadog1 15,052 PCM$
bullet baseba... 11,039 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 23,190 PCM$
bullet df_Trek 17,120 PCM$
bullet Marcovdw 16,800 PCM$
bullet jseadog1 15,000 PCM$
bullet baseball... 7,932 PCM$

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