I know this is a simple error but i cannot figure it out
Code:
cmd.CommandText = "insert into borrow (ISBNno, membername, Dateissued) values ('" & cbisbn.Text & "', '" & cbmember.Text & "', # " & DateValue(Now) & "# )"
Adding date value in sql
|
Go4Expert Member
|
|
| 6Mar2011,08:57 | #1 |
|
When i try to add this field to a database in sql i get this error "Incorrect sysntax near 3
I know this is a simple error but i cannot figure it out |