PCM.daily banner
19-09-2024 23:32
PCM.daily
Users Online
· Guests Online: 36

· Members Online: 0

· Total Members: 161,013
· Newest Member: JasonPaump
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
Shemale?
Shemale?
PCM 07: Funny Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 17,476 PCM$
bullet df_Trek 16,574 PCM$
bullet Marcovdw 14,445 PCM$
bullet jseadog1 12,852 PCM$
bullet baseba... 9,939 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 21,190 PCM$
bullet df_Trek 14,720 PCM$
bullet Marcovdw 13,900 PCM$
bullet jseadog1 12,800 PCM$
bullet baseball... 6,832 PCM$

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