Okay, I'm pulling my hair out. I'm getting NO error on the following code:
Dim cmd As New OleDb.OleDbCommand("CREATE TABLE [" + empTableName + "] ([ID] DOUBLE, " & _
"[LnameFname] TEXT(255), " & _
"[Location] TEXT(255), " & _
"[SalaryOld] DOUBLE, " & _
"[FtePercentage] DOUBLE, " & _
"[EvalScore] DOUBLE, " & _
"[EvalUnitsPerm] DOUBLE, " & _
"[EvalUnitsStipend] DOUBLE, " & _
"[EvalIncreasePerm] DOUBLE, " & _
"[EvalIncreaseStipend] DOUBLE, " & _
"[ExperienceDegreeUnits] DOUBLE, " & _
"[ExperienceDegreeIncrease] DOUBLE, " & _
"[AcademicNeedsUnitsPerm] DOUBLE, " & _
"[AcademicNeedsUnitsStipend] DOUBLE, " & _
"[AcademicNeedsIncreasePerm] DOUBLE, " & _
"[AcademicNeedsIncreaseStipend] DOUBLE, " & _
"[LeadershipUnits] DOUBLE, " & _
"[LeadershipIncrease] DOUBLE, " & _
"[Classification] TEXT(255), " & _
"[Notes] TEXT(255), " & _
"[SalaryIncrease] DOUBLE, " & _
"[Stipend] DOUBLE, " & _
"[IndividualTotalUnitsPerm] DOUBLE, " & _
"[IndividualTotalUnitsStipend] DOUBLE, " & _
"[SalaryNew] DOUBLE, " & _
"[MeetsAcademicNeeds] BIT)", frmMain.con)
frmMain.con.Open()
cmd.ExecuteNonQuery()
frmMain.con.Close()
However, right after that code I use this code and get a syntax error. Can anyone tell me why? Thanks!
Dim cmd2 As New OleDb.OleDbCommand("CREATE TABLE [" + bulkCashAmountsTableName + "] ([ID] DOUBLE, " & _
"[TeacherBulkAmountPerm] DOUBLE, " & _
"[TeacherTotalUnitsPerm] DOUBLE, " & _
"[TeacherUnitValuePerm] DOUBLE, " & _
"[TeacherBulkAmountStipend] DOUBLE, " & _
"[TeacherTotalUnitsStipend] DOUBLE, " & _
"[TeacherUnitValueStipend] DOUBLE, " & _
"[AdminBulkAmountPerm] DOUBLE, " & _
"[AdminTotalUnitsPerm] DOUBLE, " & _
"[AdminUnitValuePerm] DOUBLE, " & _
"[AdminBulkAmountStipend] DOUBLE, " & _
"[AdminTotalUnitsStipend] DOUBLE, " & _
"[AdminUnitValueStipend] DOUBLE, " & _
"[ClassifiedBulkAmountPerm] DOUBLE, " & _
"[ClassifiedTotalUnitsPerm] DOUBLE, " & _
"[ClassifiedUnitValuePerm] DOUBLE), " & _
"[ClassifiedBulkAmountStipend] DOUBLE, " & _
"[ClassifiedTotalUnitsStipend] DOUBLE, " & _
"[ClassifiedUnitValueStipend] DOUBLE)", frmMain.con)
frmMain.con.Open()
cmd2.ExecuteNonQuery()
frmMain.con.Close()
