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