In VS2005, I have specified the Parameter Prefix = "@". (Tools-Options-Database Tools-Query and View Designers-Parameter prefix = @)
Now when I try to add a new query to a dataset (data sources-edit dataset with designer-add query) and add the line "Where ProposalID = @Proid", I get the error "Generated SELECT statement, Error in WHERE clause near @, unable to parse query text".
Would anybody know why this would cause a problem? I have saved the project, rebooted etc and the prefix has stayed the same but adding the prefix @ to a query still errors out.
Any help would be great!