Database |
DB Issue 3/12/07 |
Post Reply |
Author | |
KTDupuis
Senior Member Joined: 8/29/04 Location: United States Status: Offline Points: 761 |
Post Options
Thanks(0)
Posted: 3/12/07 at 6:15am |
Kurt,
Using the online entry form, I tried to enter some addtional scores to the Zephyrhills A Division. 2 guys entered their scores already (Brent and Brian). I tried adding my scores last week and could not. I tried adding my scores in a new division (Amateur), and it worked. I just tried again to add scores for another thrower under the A division, and got the following error: DIAG:Result was previously entered DIAG:UPDATE Results SET Athletes_ID=3643, Class_ID=8369, Place=2, Points=22, Opstoneft=42, Opstonein=10, Opstonepts=679, Hwgtft=33, Hwgtin=6, Hwgtpts=674, Lwgtft=59, Lwgtin=3, Lwgtpts=637, Hhamft=83, Hhamin=8, Hhampts=680, Lhamft=111, Lhamin=2, Lhampts=737, Cabersc='80(4)', Caberpts=720, Sheafft=30, Sheafin=0, Sheafpts=851, Wfhft=13, Wfhin=0, Wfhpts=647, Decpoints=, Possiblepts=8000, NASGAsc= WHERE Results_ID=21913; Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. /dbase/resultsentry.asp, line 2709 It seems to be complaining about the scores already entered.Thanks, Kevin D |
|
"I have a right to my opinion, and my opinion is that you have no right to your opinion" - G. Carlin
|
|
admin
Admin Group Joined: 10/01/03 Location: United States Status: Offline Points: 301 |
Post Options
Thanks(0)
|
I entered your scores under the A class. There seems to be a problem with entering new results when not selecting all the events in the beginning. I had them all selected and could enter them just fine. I'll check into the problem though.
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |