
June 20th, 2005, 10:40 AM
|
|
Registered User
|
|
Join Date: Nov 2004
Posts: 22
Time spent in forums: 8 h 16 m
Reputation Power: 0
|
|
|
Function problem / VB 6
I have a function that will return a query based on the value passed in. The problem is with the query itself. I get a Compile Error: Expected: end of statement.
I receive this error right after the end of the sql statement. Any suggestions?
strQuery = "SELECT fieldid, fieldname, rep_caption, fieldorder, allowgroup, allowsort
FROM rep_fields
where alias like 'guardian%' or alias like 'x%'
order by fieldorder", <----------Error here, points to comma.
gcnData, adOpenForwardOnly, adLockReadOnly
|