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.

Horizontal Filter problem

2 posts in Replication Last posting was on 2010-09-10 11:12:12.0Z
mike grace Posted on 2010-09-10 08:52:27.0Z
Date: Fri, 10 Sep 2010 08:52:27 +0000 (UTC)
Message-ID: <b9f6cef8ddd68cd1ee502e1b873@devzone.advantagedatabase.com>
From: mike grace <mikeg@computastat-group.co.uk>
Subject: Horizontal Filter problem
Newsgroups: Advantage.Replication
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
X-Antivirus: avast! (VPS 100909-1, 09/09/2010), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 188.220.18.141
X-Trace: 10 Sep 2010 02:49:14 -0700, 188.220.18.141
Lines: 21
Path: solutions.advantagedatabase.com!188.220.18.141
Xref: solutions.advantagedatabase.com Advantage.Replication:423
Article PK: 1134276

Hi,

I have a table which I am trying to replicate. It works fine if I don't put
a horizontal filter on it but if I put the following filter on it, no rows
replicate at all.


(JOB_NO <> "" .AND. TYPE == "J" ) .OR. (JOB_NO <> "" .AND. TYPE == "C")


The above expression works in the table viewer i.e. if I set a filter so
what am I doing wrong?

I am using ADS 10.

Regards


Mike


mike grace Posted on 2010-09-10 11:12:12.0Z
Date: Fri, 10 Sep 2010 11:12:12 +0000 (UTC)
Message-ID: <b9f6cef8ddfd8cd1ef888e85732@devzone.advantagedatabase.com>
From: mike grace <mikeg@computastat-group.co.uk>
Subject: Re: Horizontal Filter problem
Newsgroups: Advantage.Replication
References: <b9f6cef8ddd68cd1ee502e1b873@devzone.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
X-Antivirus: avast! (VPS 100909-1, 09/09/2010), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 188.220.18.141
X-Trace: 10 Sep 2010 05:08:59 -0700, 188.220.18.141
Lines: 35
Path: solutions.advantagedatabase.com!188.220.18.141
Xref: solutions.advantagedatabase.com Advantage.Replication:424
Article PK: 1134278

Figured it out

If I do:

(TYPE == "J" .OR. TYPE == "C") .AND. .NOT. EMPTY(JOB_NO)

it works.

Anyone know why?

Regards


Mike

> Hi,
>
> I have a table which I am trying to replicate. It works fine if I
> don't put a horizontal filter on it but if I put the following filter
> on it, no rows replicate at all.
>
> (JOB_NO <> "" .AND. TYPE == "J" ) .OR. (JOB_NO <> "" .AND. TYPE ==
> "C")
>
> The above expression works in the table viewer i.e. if I set a filter
> so what am I doing wrong?
>
> I am using ADS 10.
>
> Regards
>
> Mike
>