471,321 Members | 2,152 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,321 software developers and data experts.

unrecognized parameters against virtual field

im creating a proof of concept in .net passing stored procedure parameters to
an Access database as the back end, using ADO. the stored procedure, in this
case a parameterized query, has a virtual field "Year"
(Format([Date_Created],"yyyy"), that is not receiving the value passed using
parameters(@Year).value, every other parameter is passed successfully except
for this one field

i've stepped through the code and watched the variables being passed and
they are being shown as the correct value but still no luck, when running the
query and passing parameters in access everything works exactly as it should

i've quadruple checked my CreateParameter("@Year") arguments and they are of
the correct data type and input, according to the field properties in Server
Explorer, but still no records are returned. without using this parameter the
correct number of records are returned. is this a known issue or should I try
ADO.net with an oledbadapter? i of course would like to be using a sql server
backend but for this proof i am limited in the resources i can request. any
help or ideas would be really appreciated

Jul 21 '05 #1
0 908

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by johkar | last post: by
3 posts views Thread by Jerry Houston | last post: by
8 posts views Thread by Sam Kuehn | last post: by
7 posts views Thread by kai | last post: by
reply views Thread by lastusernameleft | last post: by
2 posts views Thread by isaac2004 | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.