473,241 Members | 1,441 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,241 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 970

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: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.