Data not Insert
-
Hi, When I Insert data in my Access Database show error i use this query INSERT INTO trans (date,heads,debit,credit,descp) Values('2/8/2010','Jawad','0','9000','UNWASHD') Table Trans Feild....................Datatype id......................AutoNumber Date....................Datetime Heads...................text debit...................number credit..................number descp...................text ERROR "SYNTAX ERROR IN INSERT INTO STATEMENT " Plz Help Me
Jawad Khatri
-
Hi, When I Insert data in my Access Database show error i use this query INSERT INTO trans (date,heads,debit,credit,descp) Values('2/8/2010','Jawad','0','9000','UNWASHD') Table Trans Feild....................Datatype id......................AutoNumber Date....................Datetime Heads...................text debit...................number credit..................number descp...................text ERROR "SYNTAX ERROR IN INSERT INTO STATEMENT " Plz Help Me
Jawad Khatri
Date is a DateTime, you're treating it as a string. debit & credit are numbers, you're treating bpth as a string. Access, i think, uses # to denote a date in place of the quotes for strings, and numbers just dont have any quotes at all. hence:
INSERT INTO trans (date,heads,debit,credit,descp) Values(#2010-08-02#,'Jawad',0,9000,'UNWASHD')
-
Date is a DateTime, you're treating it as a string. debit & credit are numbers, you're treating bpth as a string. Access, i think, uses # to denote a date in place of the quotes for strings, and numbers just dont have any quotes at all. hence:
INSERT INTO trans (date,heads,debit,credit,descp) Values(#2010-08-02#,'Jawad',0,9000,'UNWASHD')
Same Error :(
-
Same Error :(
Depends in this: http://delphi.about.com/od/delphitips2007/qt/datetime_sql.htm[^] Date should be : #YYYY-MM-DD# DateTime should be : #yyyy-mm-dd HH:MM:SS# http://msdn.microsoft.com/en-us/library/ms714540%28VS.85%29.aspx[^] DATE and DATETIME are different
-
Hi, When I Insert data in my Access Database show error i use this query INSERT INTO trans (date,heads,debit,credit,descp) Values('2/8/2010','Jawad','0','9000','UNWASHD') Table Trans Feild....................Datatype id......................AutoNumber Date....................Datetime Heads...................text debit...................number credit..................number descp...................text ERROR "SYNTAX ERROR IN INSERT INTO STATEMENT " Plz Help Me
Jawad Khatri
-
I'm not sure about access but you shouldn't use columns with names like 'date' because this is can also be a datatype in this database.
Greetings Covean
And if you have to use such names, put them in square brackets []. Next, use a parameterized query, that will also handle the date/time problems.
INSERT INTO [trans] ([date],[heads],[debit],[credit],[descp]) Values(?,?,?,?,?)'