Dear All,

The debugger finds a syntax error in the following SQL statement:

Dim strSQL as string = "SELECT TrajectCodeID FROM TrajectCode" & _
"WHERE CLng(SelectedSoftwareFilter) = TrajectCode.SoftwareID" & _
" AND " & Cstr(SelectedKnowledgeFilter)&" =TrajectCode.VoorkennisID"&_
"AND "& Cstr(SelectedCompetenceFilter)&"=TrajectCode.Compe tentieID"

This statement queries a Database where all colomns are of type Long. The query result is intented to populate a DataGrid. SelectedKnowledgeFilter is a variable of type integer. It is used in a case statement to convert a seleted string from a combo box and assign it an integer value. The SQL error message says that my syntax is wrong after the FROM key-word.

Can someone help?
By the way, thanks to Imar who has given me a good tip on my previous posting. Problem solved, Imar. Thanks.
Christiane

Dim strSQL as string = "SELECT TrajectCodeID FROM TrajectCode " & _
"WHERE " & CLng(SelectedSoftwareFilter) & " = TrajectCode.SoftwareID " & _
"AND " & Cstr(SelectedKnowledgeFilter) & " = TrajectCode.VoorkennisID " & _
"AND " & Cstr(SelectedCompetenceFilter) & " = TrajectCode.CompetentieID"

Are these variables Cstr(SelectedCompetenceFilter), Cstr(SelectedKnowledgeFilter) text fields? If so you need single quotes.

AND TrajectCode.SoftwareID = '" & Cstr(SelectedKnowledgeFilter)& "'

By the look of it, you need a space after "TrajectCode", as when built the string will contain "TrajectCodeWHERE". Space also required after TrajectCode.VoorkennisID

HTH,

Chris