Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2004

Tip: Looking for answers? Try searching our database.

Skipif

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
New@Earthlink.com - 09 Aug 2004 19:07 GMT
Trying to figure out skipif Why does this yield NO RECORDS    

{SKIPIF { COMPARE "1" = "2" } }

When without it I have 50 records?
Peter Jamieson - 09 Aug 2004 19:49 GMT
It's because SKIPIF needs the following syntax

{ SKIPIF expression1 comparison-operator expression2 }

so e.g.

{ SKIPIF "1" = "2" }

or

{ SKIPIF { COMPARE "1" = "2" }  = 1 }

should yield all the records,

{ SKIPIF "1" = "1" }

or

{ SKIPIF { COMPARE "1" = "1" }  = 1 }

should yield no records.

As far as I know you cannot replace

expression1 comparison-operator expression2

by a scalar value of any type and have SKIPIF do anything except SKIP
everything, e.g.

{ SKIPIF 1 }

{ SKIPIF 0 }

{ SKIPIF -1 }

{ SKIPIF "A" }

will all yield no records, and by doing

{SKIPIF { COMPARE "1" = "2" } }

you are in effect doing

{ SKIPIF 0 }

Signature

Peter Jamieson

> Trying to figure out skipif Why does this yield NO RECORDS
>
> {SKIPIF { COMPARE "1" = "2" } }
>
> When without it I have 50 records?
grep - 09 Aug 2004 21:30 GMT
Because "1" and "2" are strings and will NEVER match. Since they never
match, all records are skipped.

grep

> Trying to figure out skipif Why does this yield NO RECORDS    
>
> {SKIPIF { COMPARE "1" = "2" } }
>
> When without it I have 50 records?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.