martin123123
Programmer
hi everyone.
there seems to be a problem when i try to execute this sentence:
'InsertSql = "insert into abolagre values('" + TXT1.Text + "'," + DateTime.Date$ + "
"
Now the sql sentence will be something like this:
InsertSql =
"insert into abolagre values('hello','07-07-2003')"
But when i try to run
myConnection.Execute(InsertSql)
i get the error:
syntax error converting datetime from character string
i've also tried to remove the quote marks on the date, but it still doesn't work.
what am I doing wrong?
there seems to be a problem when i try to execute this sentence:
'InsertSql = "insert into abolagre values('" + TXT1.Text + "'," + DateTime.Date$ + "
Now the sql sentence will be something like this:
InsertSql =
"insert into abolagre values('hello','07-07-2003')"
But when i try to run
myConnection.Execute(InsertSql)
i get the error:
syntax error converting datetime from character string
i've also tried to remove the quote marks on the date, but it still doesn't work.
what am I doing wrong?