Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Visual Basic ( VB ) (http://www.go4expert.com/forums/visual-basic/)
-   -   Adding date value in sql (http://www.go4expert.com/forums/adding-date-value-sql-t25161/)

bouki 6Mar2011 08:57

Adding date value in sql
 
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

Code:

cmd.CommandText = "insert into borrow (ISBNno, membername, Dateissued) values ('" & cbisbn.Text & "', '" & cbmember.Text & "', # " & DateValue(Now) & "#  )"


All times are GMT +5.5. The time now is 04:34.