Does anyone have any expreience with the order of fields in a OleDb INSERT
command being significant.
It seems that
db.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("INSERT INTO
StagesProcessing (ptrOrder,StageDate,fromStage,toStage) VALUES
(@p_ptrOrder,@p_StageDate,@p_fromStage,@p_toStage)",cn);
will work but
db.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("INSERT INTO
StagesProcessing (ptrOrder,fromStage,toStage,StageDate) VALUES
(@p_ptrOrder,@p_fromStage,@p_toStage,@p_StageDate)",cn);
will not work?
ptrOrder is a GUID
fromStage is a TEXT
toStage is a TEXT
StageDate is a DATETIME
the database is Access 2002
I've never had any problems using dates before.
Thanks