Query Problems

[jimmy]

Hi

In my application i have a dataSet which has been created by the
designer. I have added the following query to one of the tables;

------------------------------------------------------------------------------------------------------------------------------------------------

INSERT INTO reservationsTbl
(OrderID, CustomerID, Time, PartySize, Date)
VALUES (@OrderID, @CustomerID,@Time,@PartySize,@Date)

------------------------------------------------------------------------------------------------------------------------------------------------

I now have the following code to try and execute this query;

------------------------------------------------------------------------------------------------------------------------------------------------

Dim reservationsAdapter As New
dsTableAdapters.reservationsTblTableAdapter
Try
reservationsAdapter.InsertReservation(10, ID,
TimeTxt.Text, PartySizeTxt.Text, DatePicker.Value)
Catch ex As Exception
MsgBox("Inserting new record failed. " + ex.Message)
End Try

------------------------------------------------------------------------------------------------------------------------------------------------

No error message is shown when the code is executed however the record
is not inserted. Can anyone help?

Thanks in advance!

 

[Master Programmer]

The word "Date" is an sql reserved word. The worrd "Time looks a bit
dodgy as well. Change the table name to something else or escape it by
changing the sql query to this....

INSERT INTO reservationsTbl
(OrderID, CustomerID, [Time], PartySize, [Date])
VALUES (@OrderID, @CustomerID,@Time,@PartySize,@Date)


The Grand Master
"When you have reached the top of the mountain
you can look down at everyone else."

 

[Master Programmer]

"Thanks for your help" would have been nice. Ignorant shit !

 

[jimmy]

I'm sorry but i have only just checked the thread! Thanks anyway

 

[jimmy]

IT WORKS! Thanks for that... it would have taken me ages to figure out
otherwise

 

[FishingScout]

He did thank you, you illiterate putz! Read his message.

I am impressed that you actually help someone. (by the way, you don't
need to thank me for that nice comment)

 

[Master Programmer]

thanks

The Grand Master

He did thank you, you illiterate putz! Read his message.

I am impressed that you actually help someone. (by the way, you don't
need to thank me for that nice comment)