troubleshooting Question

Parameter Query not accepting Parameter Prefix

Avatar of wayneburr
wayneburr asked on
Visual Basic.NET
14 Comments1 Solution2617 ViewsLast Modified:
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!

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 14 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros