Syntax error in INSERT? The SQL stmt is generated by DS(?)
Posted: Thu Jul 05, 2001 4:07 pm
Can someone see something here that would be causing this error? Im loading from teh SAP plugin into a MDB. All the fields are described as "Nullable".
Thanks,
dave
S701Extract.PickGoodRecords.BreederStatsUploadODBC: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO `BreederStatsUpload`(RRN, ORDER, PROCESS_DATE, PLANT, FARM, AGE_WK, MOVED, CAPITL, HENS_ON_FARM, MALES_ON_FARM, CLASS1_EGGS, CLASS2_EGGS, CLASS3_EGGS, S701_ZGP_PROCES, S701_ZGP_WEEK, S701_ZGP_YEAR, PLACE_DATE) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
SQLSTATE=37000, DBMS.CODE=-3502
[Ardent][SQL Client][ODBC][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
RRN = 8529
ORDER = "000100768668"
PROCESS_DATE = "07/07/01"
PLANT = "LP20"
FARM = "LP2P4082"
AGE_WK = 21
MOVED = NULL
CAPITL = NULL
HENS_ON_FARM = 0
MALES_ON_FARM = 0
CLASS1_EGGS = NULL
CLASS2_EGGS = NULL
CLASS3_EGGS = NULL
S701_ZGP_PROCES = "20010707"
S701_ZGP_WEEK = "40"
S701_ZGP_YEAR = "2001"
PLACE_DATE = "02/10/01"
Thanks,
dave
S701Extract.PickGoodRecords.BreederStatsUploadODBC: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO `BreederStatsUpload`(RRN, ORDER, PROCESS_DATE, PLANT, FARM, AGE_WK, MOVED, CAPITL, HENS_ON_FARM, MALES_ON_FARM, CLASS1_EGGS, CLASS2_EGGS, CLASS3_EGGS, S701_ZGP_PROCES, S701_ZGP_WEEK, S701_ZGP_YEAR, PLACE_DATE) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
SQLSTATE=37000, DBMS.CODE=-3502
[Ardent][SQL Client][ODBC][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
RRN = 8529
ORDER = "000100768668"
PROCESS_DATE = "07/07/01"
PLANT = "LP20"
FARM = "LP2P4082"
AGE_WK = 21
MOVED = NULL
CAPITL = NULL
HENS_ON_FARM = 0
MALES_ON_FARM = 0
CLASS1_EGGS = NULL
CLASS2_EGGS = NULL
CLASS3_EGGS = NULL
S701_ZGP_PROCES = "20010707"
S701_ZGP_WEEK = "40"
S701_ZGP_YEAR = "2001"
PLACE_DATE = "02/10/01"