473,397 Members | 2,099 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 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 979

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: johkar | last post by:
I need a hint (a big hint) on how to use XSL variables and parameters. It is definitely not clicking yet. Below is my XML stripped down. There are multiple Extension nodes and multiple...
2
by: Susan Bricker | last post by:
Greetings Experts ... I have a routine that is invoked when a command button is clicked. The button is located in a form that is tied to a table of Project records. Each Project Record has 0 to...
8
by: Nanda | last post by:
hi, I am trying to generate parameters for the updatecommand at runtime. this.oleDbDeleteCommand1.CommandText=cmdtext; this.oleDbDeleteCommand1.Connection =this.oleDbConnection1;...
3
by: Jerry Houston | last post by:
In a winform application, I use worker threads to perform asynchronous tasks (e.g., mail merge with Word). The thread procs need to gather some user options from controls in the UI, and I know...
8
by: Sam Kuehn | last post by:
How do I accomplish the fallowing (is it even possible). Say I write a UserControl "MyControl.ascx". Now I use LoadControl("MyControl.ascx"). But I really want MyControl to require parameters in...
7
by: kai | last post by:
Hi, I have XP Pro and VS2005 final version. I have been running some examples from a MS Press books (ASP.NET 2.0 Core Reference and), I run into this problems: Parser Error Message:...
0
by: lastusernameleft | last post by:
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...
2
by: isaac2004 | last post by:
hi am getting this error about a wrong field name in my database and it all seems right to me <%@ Language=VBScript %> <% Option Explicit %> <!--#include file="DatabaseConnect.asp"-->...
0
by: howardr101 | last post by:
Hi, Have hunted around on the groups and can't find anything, hence. I've tried this against 2 mail servers (mailtraq and hmailserver) and it occus with both. The problems seems to be that...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

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.