Ad:

Visual Basic 4 / 5 / 6 Discussion Thread
Unsolved
Views: 608

May 1st, 2009

SQL problem - simple?

Expand Post »

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:

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?

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 & "')"

Similar Threads

Updated : Simple ASP.Net Login Page in ASP.NET
my sql problem in PHP
Copy records from one table to samme table in another sql server in MS SQL
multiple checkboxes adding values to single sql column in PHP
Simple Question PLease URGENT in MS SQL

kn2790

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

30 posts
since Apr 2009

Permalink

May 1st, 2009

Re: SQL problem - simple?

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.

Zermoth

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Dec 2008

Permalink

May 1st, 2009

Re: SQL problem - simple?

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

kn2790

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

30 posts
since Apr 2009

Permalink

May 2nd, 2009

Re: SQL problem - simple?

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.

debasisdas

Featured Poster

Reputation Points: 665

Solved Threads: 427

Posting Genius

Offline

6,406 posts
since Feb 2007

Permalink

May 7th, 2009

Re: SQL problem - simple?

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

QVeen72

Reputation Points: 84

Solved Threads: 140

Posting Shark

Offline

923 posts
since Nov 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Denying Access Database

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: need help with VB6

DaniWeb Message

Cancel Changes

User Name
Password