Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

RecordSet Filter using ADO/OLEDB

2 posts in FoxPro Last posting was on 2005-06-03 20:41:32.0Z
Tom Clark Posted on 2005-06-03 20:34:24.0Z
From: "Tom Clark" <tjclark@pc-enable.com>
Newsgroups: advantage.foxpro
Subject: RecordSet Filter using ADO/OLEDB
Date: Fri, 3 Jun 2005 13:34:24 -0700
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 24.116.122.174
Message-ID: <42a0c067@solutions.advantagedatabase.com>
X-Trace: 3 Jun 2005 14:41:11 -0700, 24.116.122.174
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!24.116.122.174
Xref: solutions.advantagedatabase.com Advantage.FoxPro:193
Article PK: 1109546

Hi All,

I am having trouble using a RecordSet filter when there are spaces in the
field name.

This works:

oRS.Filter = [Provider = 'REL']

This does not work:

oRS.Filter = [Claim Status 1 = '1']

Nor does this:

oRS.Filter = ["Claim Status 1" = '1']

Nor any other variation that I can come up with.

TIA,
Tom Clark


Tom Clark Posted on 2005-06-03 20:41:32.0Z
From: "Tom Clark" <tjclark@pc-enable.com>
Newsgroups: advantage.foxpro
References: <42a0c067@solutions.advantagedatabase.com>
Subject: Re: RecordSet Filter using ADO/OLEDB
Date: Fri, 3 Jun 2005 13:41:32 -0700
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 24.116.122.174
Message-ID: <42a0c212@solutions.advantagedatabase.com>
X-Trace: 3 Jun 2005 14:48:18 -0700, 24.116.122.174
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!24.116.122.174
Xref: solutions.advantagedatabase.com Advantage.FoxPro:194
Article PK: 1109548

Hi All,

Murphy to the rescue. In less than 3 minutes after posting I found syntax
that seems to work.

i.e.

oRS.Filter = "[Claim Status 1] = '1'"

Thanks,
Tom Clark

"Tom Clark" <tjclark@pc-enable.com> wrote in message
news:42a0c067@solutions.advantagedatabase.com...
> Hi All,
>
> I am having trouble using a RecordSet filter when there are spaces in the
> field name.
>
> This works:
>
> oRS.Filter = [Provider = 'REL']
>
> This does not work:
>
> oRS.Filter = [Claim Status 1 = '1']
>
> Nor does this:
>
> oRS.Filter = ["Claim Status 1" = '1']
>
> Nor any other variation that I can come up with.
>
> TIA,
> Tom Clark
>