|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Problems with SQL INSERT vb
This is used on an VB.net webform to insert a row in an access table. I get the following error no matter what I try,
"Syntax error in INSERT INTO statement" Here is my SQL; INSERT Into CalendarEvent (JobNo, DateStarted, Time, Desc, TypePerson, Scheduler) VALUES ('1014', '7/3/2005', '3:00', '3 Rm Carpet', 'OnLoCrew', 'bud') All fields in the database are text fields so this shouldn't be a data type issue. I've checked 1,000 times to make sure my fields are named appropriately. Any help is appreciated! |
|
#2
|
||||
|
||||
|
Hi,
I am not sure what database your are using, but my guess is that Time and Desc are reserved words in the database your are using, try the following: Code:
INSERT INTO CalendarEvent ([JobNo], [DateStarted], [Time], [Desc], [TypePerson], [Scheduler]) VALUES ('1014', '7/3/2005', '3:00', '3 Rm Carpet', 'OnLoCrew', 'bud')
hope this helps
__________________
Look! Its a ShemZilla ![]() ![]()
|
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Problems with SQL INSERT vb |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|