too few parameter error in SQL Statement...plz help!

[deane034]

hi guys this is the code i am using when i run this coode Vb gives me a too few parameter err....these SQL code was genarated in MS Access.. the Group and class and course are all String Varables..i am using Dao 3.6...can anyone find whatz wrong?



SQLString = " SELECT Class_Table.StNo, Class_Table.Group, Class_Table.Course, Class_Table.Class" & _
" From Class_Table" & _
" WHERE (((Class_Table.Group)=" & _
Group & ") AND ((Class_Table.Course)=" & Course & ") AND ((Class_Table.Class)=" & Class & "));"



Set RS = DB.OpenRecordset(SQLString)

[mendhak]

I think the compiler was being sarcastic with you... too few parenthesis. (kidding )

SQLString = " SELECT Class_Table.StNo, Class_Table.Group, Class_Table.Course, Class_Table.Class" & _
" From Class_Table" & _
" WHERE (((Class_Table.Group)='" & _
Group & "') AND ((Class_Table.Course)='" & Course & "') AND ((Class_Table.Class)='" & Class & "'));"

[deane034]

thanks man i'll try it out..and see if there is a problem inda morinin....

[mendhak]

btw, where in sri lanka do you live? I was in Colombo at... uhm.. Melrose Avenue for about 3 years.

[deane034]

Cool...i live close to Negombo..... are u sri lankan?....if u are...u are the 2nd one i met here...i also met someone called JANAKA...ela ela machan..

[mendhak]

Sorry 2 disappoint. I'm not Sri Lankan. And I didn't even understand half of the stuff you spewed there... Negombo... uhm.. I've been to Colombo and Kandy, where I was attacked by an alligator... and I don't know Sinhalese.
lol.