DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

SQL problem - simple?

•

Join Date: Apr 2009

Posts: 30

Reputation: kn2790 is an unknown quantity at this point

Solved Threads: 0

kn2790

Offline

Light Poster

SQL problem - simple?

May 1st, 2009

so im trying 2 add data to my table in the database, done all the connection (OLEDB one)

so this code adds to my database:

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
    SQL = "Insert into Bookings(StaffID) values('" & stafid.Text & "')"
        DC1 = New OleDbCommand(SQL, cN)
        DC1.ExecuteNonQuery()
        MsgBox("Record Saved, Thank you!", MsgBoxStyle.OkOnly, "")
    SQL = "Insert into Bookings(StaffID) values('" & stafid.Text & "')"
        DC1 = New OleDbCommand(SQL, cN)
        DC1.ExecuteNonQuery()
        MsgBox("Record Saved, Thank you!", MsgBoxStyle.OkOnly, "")

this is one column, im trying to add more to the table StaffID

whats wrong with this SQL statement to add all the fields to the database?

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
SQL = "Insert into Bookings(StaffID,RoomID,Date required,Time required,Additional requirements) values('" _
            & "'" & stafid.Text & "', " _
            & "'" & rooid.Text & "', " _
            & "'" & date1.Text & "', " _
            & "'" & time1.Text & "', " _
            & "'" & areq.Text & "')"
SQL = "Insert into Bookings(StaffID,RoomID,Date required,Time required,Additional requirements) values('" _
            & "'" & stafid.Text & "', " _
            & "'" & rooid.Text & "', " _
            & "'" & date1.Text & "', " _
            & "'" & time1.Text & "', " _
            & "'" & areq.Text & "')"

•

Join Date: Dec 2008

Posts: 8

Reputation: Zermoth is an unknown quantity at this point

Solved Threads: 0

Zermoth

Offline

Newbie Poster

Re: SQL problem - simple?

May 1st, 2009

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
& "'" & stafid.Text & "', " _
            & "'" & rooid.Text & "', " _
            & "'" & date1.Text & "', " _
            & "'" & time1.Text & "', " _
            & "'" & areq.Text & "')"
& "'" & stafid.Text & "', " _
            & "'" & rooid.Text & "', " _
            & "'" & date1.Text & "', " _
            & "'" & time1.Text & "', " _
            & "'" & areq.Text & "')"

rename rooid.Text to roomid.Text

also

stafid.Text to staffid.Text

if thats not the correct names

Last edited by Zermoth; May 1st, 2009 at 11:16 am.

•

Join Date: Apr 2009

Posts: 30

Reputation: kn2790 is an unknown quantity at this point

Solved Threads: 0

kn2790

Offline

Light Poster

Re: SQL problem - simple?

May 1st, 2009

lol no they are the correct names of the textboxes, any other ideas?

•

Join Date: Feb 2007

Posts: 2,093

Reputation: debasisdas will become famous soon enough

Solved Threads: 125

debasisdas debasisdas is online now

Online

Postaholic

Re: SQL problem - simple?

May 2nd, 2009

what exactly is the error message .

print the SQL string or display in A message box before executing the same. SO that yo can check if the SQL is being framed properly or not.

Share your Knowledge.

•

Join Date: Nov 2006

Posts: 848

Reputation: QVeen72 is on a distinguished road

Solved Threads: 120

QVeen72

Offline

Practically a Posting Shark

Re: SQL problem - simple?

May 7th, 2009

Hi,

Field Names which have SpecialCharacters/Spaces, need to be enclosed in a Square Bracket..
Try This :

SQL = "Insert into Bookings(StaffID,RoomID,[Date required]," _
& " [Time required],[Additional requirements]) values('" _
& "'" & stafid.Text & "', " _
& "'" & rooid.Text & "', " _
& " #" & date1.Text & "#, " _
& " #" & time1.Text & "#, " _
& "'" & areq.Text & "')"

Also, Date/Time Fields need to to be wrapped in with #, instead of single quote.

Regards
Veena