Dates are really working against me this week.
Problem im having today is that I take a dataset from an access table, store it as an xml file and transfer it to a Windows CE.net device. Once on the device a service is run to extract the data from the dataset and insert it into a SQL Ce database. The problem I am having is (feel really stupid asking this), how do you insert dates into a sql ce table. I havethe field defined as a DateTime field and am using whatI thought to be the correct insert statement.
Everytime i execute this it returns a token error. Any ideas guys?
Problem im having today is that I take a dataset from an access table, store it as an xml file and transfer it to a Windows CE.net device. Once on the device a service is run to extract the data from the dataset and insert it into a SQL Ce database. The problem I am having is (feel really stupid asking this), how do you insert dates into a sql ce table. I havethe field defined as a DateTime field and am using whatI thought to be the correct insert statement.
VB.NET:
INSERT INTO Schedule(InspectionID ,inspectionDate, inspector, type)
VALUES ( '40','20',#2005-08-26#, '1080','Annual')
Everytime i execute this it returns a token error. Any ideas guys?