Public Sub [B]SaveHorseListData[/B]
ErrorLabel(HseListErr)
' create parameters
cmd.AddParameter("RaceID")
cmd.AddParameter("TAB")
cmd.AddParameter("HorseName")
cmd.AddParameter("E")
.....
.....
cmd.CommandText = "INSERT INTO " & HorseFileName & " (HID, RaceID, TAB, HorseName, E, Cty, ThisForm, " & _
"Barrier, NewBar, Weight, FWD, WDOds, FWW, WWOds, FSD, SDOds, FSW, SWOds, AdjRate, HorseAge, HorseType, " & _
"HorseSex, HorseTrainer, HorseTrainerLoc, Jockey, Allow, QTABJock, Career, Runs, Ws, Ps, APIs, " & _
"CurAPIs, WinDist, ThisDist, ThisCourse, Fast, Good, Dead, Slow, Heavy, FUp, SUp, ThisDistPC, " & _
"ThisCoursePC, FastPC, GoodPC, DeadPC, SlowPC, HeavyPC, FUpPC, SUpPC, DLS, Breed, Owner, Silks, " & _
"RunsBack, RBLetUp, WRPos, SRPos, PcePos, APIPos, PsPos, WsPos, DDist, DWgt, HPace, BlkBk, FS) " & _
"VALUES (null, @RaceID, @TAB, @HorseName, @E, @Cty, @ThisForm, @Barrier, @NewBar, @Weight, @FWD, @WDOds, " & _
"@FWW, @WWOds, @FSD, @SDOds, @FSW, @SWOds, @AdjRate, @HorseAge, @HorseType, @HorseSex, @HorseTrainer, " & _
"@HorseTrainerLoc, @Jockey, @Allow, @QTABJock, @Career, @Runs, @Ws, @Ps, @APIs, @CurAPIs, @WinDist, " & _
"@ThisDist, @ThisCourse, @Fast, @Good, @Dead, @Slow, @Heavy, @FUp, @SUp, @ThisDistPC, @ThisCoursePC, " & _
"@FastPC, @GoodPC, @DeadPC, @SlowPC, @HeavyPC, @FUpPC, @SUpPC, @DLS, @Breed, @Owner, @Silks, @RunsBack, " & _
"@RBLetUp, @WRPos, @SRPos, @PcePos, @APIPos, @PsPos, @WsPos, @DDist, @DWgt, @HPace, @BlkBk, @FS)"
cmd.SetParameter("RaceID", RHse.RaceID)
cmd.SetParameter("TAB", RHse.TAB)
cmd.SetParameter("HorseName", RHse.HorseName)
cmd.SetParameter("E", RHse.E)
cmd.SetParameter("Cty", RHse.Cty)
cmd.SetParameter("ThisForm", RHse.ThisForm)
....
....
cmd.ExecuteNonQuery
Return
HseListErr:
Msgbox("Adding Horse to Database failed!", "Horse Error", cMsgboxOK, cMsgboxHand)
Return
End Sub