473,321 Members | 1,708 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,321 software developers and data experts.

Filter ADO Recordset Error

Hi All,

First off I'd like to mention that I know this should be done in
ADO.NET, but I have been asked to do it in regular ADO. =( Having said
that, here is the problem I am experiencing...

I'm working with VB.NET and I have a recordset and I am trying to set a
filter on it. I am getting an error that says "Arguments are of the
wrong type, are out of acceptable range, or are in conflict with one
another." Here is the code I am using:

Dim rs As ADODB.Recordset
rs = GetRecordset("SELECT * FROM Test", adUseClient, adLockReadOnly,
adOpenStatic, GetMainConn, True)
rs.Filter = "test"

I checked the filter immediately after I get the recordset and I notice
that the filter has a value of 0 {Integer}. I also verified that the
rs has the correct number of records. Can anyone help me with this
error???

Many thanks...

Nov 21 '05 #1
4 4123
<uf*********@yahoo.com> schrieb
Hi All,

First off I'd like to mention that I know this should be done in
ADO.NET, but I have been asked to do it in regular ADO. =( Having
said that, here is the problem I am experiencing...

I'm working with VB.NET and I have a recordset and I am trying to
set a filter on it. I am getting an error that says "Arguments are
of the wrong type, are out of acceptable range, or are in conflict
with one another." Here is the code I am using:

Dim rs As ADODB.Recordset
rs = GetRecordset("SELECT * FROM Test", adUseClient, adLockReadOnly,
adOpenStatic, GetMainConn, True)
rs.Filter = "test"
"test" what? Filter needs an expression, like "name = 'miller'".

http://msdn.microsoft.com/library/en...dprofilter.asp
I checked the filter immediately after I get the recordset and I
notice that the filter has a value of 0 {Integer}. I also verified
that the rs has the correct number of records. Can anyone help me
with this error???

Many thanks...

Armin

Nov 21 '05 #2
Hi,

Thank you for your response. I know that the filter needs an
expression....I was trying to illustrate that it does not matter what
text I set the filter to. I am getting the error because the filter is
of type Integer and I am setting it equal to an expression (of any
value) of type String.

Do you know why this is not working???

Nov 21 '05 #3
"GatorBait" <MP****@gmail.com> schrieb
Hi,

Thank you for your response. I know that the filter needs an
expression....I was trying to illustrate that it does not matter
what text I set the filter to. I am getting the error because the
filter is of type Integer and I am setting it equal to an expression
(of any value) of type String.

Do you know why this is not working???


I thought the value of the property is Integer, not the data type of the
property. The message you get, is it a runtime exception or a compiler
message? I guess the latter. I'm afraid, I won't have an answer anyway, but
you might turn to an ADO or Framework.Interop group as this question is not
related to the VB.Net language (what I am (hopefully) better in).
Armin

Nov 21 '05 #4
ok, thanks for the effort

Nov 21 '05 #5

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

Similar topics

0
by: gary artim | last post by:
Hi All, I have a problem using DBIx::RecordSet. I get correct results but continue to get these messages on stderr. I looked at Compat.pm and it seems to be pointing out a problem with my call...
9
by: heruti | last post by:
Hi all... I've been stumped by this for days. Bit of ASP code: (IIS) Set LocalConn = CreateObject("ADODB.Connection") LocalConn.CursorLocation = adUseClient LocalConn.CommandTimeout = 0...
1
by: Mark | last post by:
All, I have the following function which is returning an error which I have found to be due to the criteria of the SQL. Could anyone offer any suggestions on how I can achieve the same results by...
4
nitindel
by: nitindel | last post by:
Hi All, I am using DbCom Handler for my DataBase Connectivity. But the Query is not firing i.e recordset is not getting populated... it is Showing the error as follows: ...
1
by: lxxslay3rxxl | last post by:
Let's say I haf 3 project that I wan to list, each project should have 1 value assign to it, but if i remove 1 of the value for 1 of the project, and i tried to list all 3 projects, I get this error:...
0
by: Neelesh2007 | last post by:
Hi all, I have project with VB6.0 and Access-2003. I have datagrid and ADODC as datasource to retrieve records from database. To export the data of datagrid to Excel I am using Copy From Recordset...
18
reginaldmerritt
by: reginaldmerritt | last post by:
When opeing and closing a DAO recordset a few times i get the following error message: I've been google and forum investigating all day. The only thing i have found is information on...
15
by: dowlingm815 | last post by:
The code below uses a query as a dataset. I have used this code in the past and it works fine. However, it is now generating a error : Invalid Arguement. any suggestions would be appreaciate: ...
1
by: JpjVB | last post by:
I'm having difficulty filtering a form using a multiselect list box when using some Allen Browne code. I get the error "Syntax Error (missing operator)in query expression '( IN (""Sydney"London)'. -...
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...
1
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.