hellow experts.
first of all you should forgive me for my poor english.
I am new with MS access 2003, I want to insert a record to my table, I am useing Parameters to do that. an error is always occur, the error is:
"Syntax error in INSERT INTO statement"
my table has 30 fields, three of the fields are date fields. and now I'm almost sure that my problem is something around that.
please can you tell me what I need to enter date using parameters.
my code is:
cmd.Parameters .Add (new OleDbParameter("#"@pcal1"#",TextBox1.Text));
cmd.Parameters .Add (new OleDbParameter("#"@pcal2"#",TextBox2.Text));
...
...
...
cmd.CommandText="insert into REQUEST(REQBY,REQDATE,REQREALDATE,REQREALTIME,ROJECTID,PROJMANAGERID,OBJECT,ANOTHERDEPENDONIT,DEPENDONANOTHER,TECHNICALINT,MATERIALID,CONCERNEDPARDOM,FILIALID,EVOLUTIVE,CORRECTIVE,FUNCTIONALINT,APPLICATIONID,IMPACTONMON,IMPACTONPROC,OPERATIONFILEID,ARCHFILEID,INTIWH,INTAWH,SENSITIVE,USERSIMPACTED,USERSTEST,SERVERBOOT,EXCEPTIONALB,CONSTRAINTS,RESTOREBACKUP,OTHERPROCEDURE)values(@preqby,@pcal1,@pcal2,@prrh,@ppro,@pprom,@pob,@paidot,@ptidoan,@pti,@pmatn,@pcpd,@pfid,@pevo,@pcor,@pfi,@papn,@pimp,@picfo,@popfn,@parfn,@piwh,@pawh,@psen,@pui,@put,@psbn,@pexb,@pcidt,@preb,@poproc)";

Please Help.