TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ZULFAHMI AIDI
NA
8
0
sysntax Error in INSERT INTO statement
Mar 23 2010 11:56 PM
Hi there,
I got a problem here where my insert statement have an error when i try to run the insert command.
the insert command
OleDbCommand = New OleDbCommand("INSERT INTO PMRTable (PMRDate, PMRTime, ReportID, PatientID, Level, Alergik, StatusReport, StatusMedication, MedDigo, MedAsprin, MedStrep, MedIso, DosMedDigo, DosMedAsprin, DosMedStrep, DosMedIso, TotalMedDigo, TotalMedAsprin, TotalMedStrep, TotalMedIso, PerDayMedDigo, PerDayMedAsprin, PerDayMedStrep, PerDayMedIso,TimeMedDigoAm, TimeMedDigoMid, TimeMedDigoPM, TimeMedAsprinAm, TimeMedAsprinMid, TimeMedAsprinPm, TimeMedStrepAm, TimeMedStrepMid, TimeMedStrepPm, TimeMedIsoAm, TimeMedIsoMid, TimeMedIsoPm, StartDate, ReminderDate, EndDate, DayDuration) VALUES ('" & todayDate.Text & "', '" & timeToday.Text & "', '" & txtRID.Text & "', '" & txtPID.Text & "', '" & txtRLevel.Text & "', '" & cmbAlergik.Text & "', '" & txtStatus.Text & "','" & txtStaMedi.Text & "','" & cbDigo.Text & "','" & cbAs.Text & "','" & cbStrep.Text & "','" & cbIso.Text & "','" & txtDosMedDigo.Text & "', '" & txtDosMedAsprin.Text & "', '" & txtDosMedStrep.Text & "', '" & txtDosMedIso.Text & "', '" & txtTotalMedDigo.Text & "','" & txtTotalMedAsprin.Text & "','" & txtTotalMedStrep.Text & "','" & txtTotalMedIso.Text & "','" & txtPerDayMedDigo.Text & "','" & txtPerDayMedAsprin.Text & "','" & txtPerDayMedStrep.Text & "','" & txtPerDayMedIso.Text & "','" & txtcbMedDigoAm.Text & "', '" & txtcbMedDigoMid.Text & "' , '" & txtcbMedDigoPM.Text & "', '" & txtcbMedAsprinAm.Text & "', '" & txtcbMedAsprinMid.Text & "', '" & txtcbMedAsprinPm.Text & "' , '" & txtcbMedStrepAm.Text & "', '" & txtcbMedStrepMid.Text & "', '" & txtcbMedStrepPm.Text & "', '" & txtcbMedIsoAm.Text & "', '" & txtcbMedIsoMid.Text & "', '" & txtcbMedIsoPm.Text & "', '" & txtStartDate.Text & "', '" & txtReminderDate.Text & "', '" & txtEndDate.Text & "','" & txtDayDuration.Text & "' )", OleDbConnection)
I have check the the Tablename, the field in the table, the connection string, but it still cant prompt the error "sysntax Error in INSERT INTO statement". Anyone help me with this. I attach along the form and the database.
Form: formPharma
Table:MRMS
Attachment:
MRMS.rar
Reply
Answers (
0
)
Cant load data using time
convert vb8 textboxes to excel 2007 adding always in the same sheet but in next lines