sql and variables

Morn

Active member
Joined
Dec 4, 2006
Messages
40
Programming Experience
Beginner
I am having a problem with an sql statements in my VB.net form.

The DB is access and the sql is as follows:

VB.NET:
SELECT [firstname], [surname], [activityId] FROM tblTraveler WHERE [bookingID] = booking
Booking is a integer variable, I am not to sure if I have entered the variable correctly into the sql.

When I run it it says that there is a missing parameter.

Can anyone see the problem here?

Thanks in advance

Graham
 
Back
Top