Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Newbie help: Where's the syntax error????

140 views
Skip to first unread message

BroncoSaurus

unread,
May 25, 1999, 3:00:00 AM5/25/99
to
I'm trying to set up a validation formula to make a field a "required entry"
field. I referred to page 352, in PCWeek's "Guide to Lotus Notes/R4" and
attempted to copy the syntax used there. I thought I had it correct, but
Notes keeps burping back that I'm missing and argument, or a bracket, or a
semi-colon . . . depending on how I've tried to move things around. I'm
getting frustrated and would greatly appreciate it if someone could look at
the following code snippet and tell me where I'm fouling things up.

@If( (Company <> "") ; @Success ;
@Failure("Some Warning") )

Like I said except for the field name and the quoted text, it appears
identical to the example I am referring to, but Notes doesn't like it. It
always points to the last couple of characters for the error if that helps.

Claire Langton

unread,
May 25, 1999, 3:00:00 AM5/25/99
to
The formula syntax for not equals is != so try this:

@If( (Company != "") ; @Success ;@Failure("Some Warning") )


Hope this helps

Claire

--
Claire Langton
Notes Consultant
ALTIS Consulting Limited
Telephone: +44 (0) 1635 867575
Fax.: +44 (0) 1635 867576
Mobile: +44 (0) 7887 500528
Internet: www.altisltd.com
E-Mail: claire_...@altisltd.com

A Lotus Premium Business Partner
A !Candle Business Partner


Omicron

unread,
May 25, 1999, 3:00:00 AM5/25/99
to
>
@If( (Company <> "") ; @Success ;

@Failure("Some Warning") )
>
> Like I said except for the field name and the quoted text, it appears
> identical to the example I am referring to, but Notes doesn't like it. It
> always points to the last couple of characters for the error if that
helps.
>
>
The syntax looked fine to me so I just copied the exact text above, pasted
it into an agent and got no complaints from Notes. No real help, sorry.

Omicron


BroncoSaurus

unread,
May 25, 1999, 3:00:00 AM5/25/99
to
I tried your example and got "An operator or semicolon was expected but none
was encountered: ')' "
and it highlights the last right parenthesis

Which is what I was getting before. Any ideas?

Claire Langton wrote in message
<927662433.13686.0...@news.demon.co.uk>...

Omicron

unread,
May 25, 1999, 3:00:00 AM5/25/99
to
Egads!

There is a case of the computer doing things behind your back. I missed the
<> issue because, R5 corrected it automatically when I typed it in.

<grins>

Omicron

Claire Langton <cla...@granvilleroad.demon.co.uk> wrote in message
news:927662433.13686.0...@news.demon.co.uk...

BroncoSaurus

unread,
May 25, 1999, 3:00:00 AM5/25/99
to
ACK! I knew I should have started drinking earlier today . . .

But I am on R4 . . . any clues?


Omicron wrote in message <7if286$etg$1...@oak.prod.itd.earthlink.net>...

Scaba

unread,
May 26, 1999, 3:00:00 AM5/26/99
to
BroncoSaurus,

Do you have any statements in your formula after this one? If so,
you'll need a semicolon at the end of this statement.

<== Scaba ==>

On Tue, 25 May 1999 19:42:46 GMT, "BroncoSaurus"
<t...@nospamplease.inr.net> had the unmitigated audacity to say:

|I'm trying to set up a validation formula to make a field a "required entry"
|field. I referred to page 352, in PCWeek's "Guide to Lotus Notes/R4" and
|attempted to copy the syntax used there. I thought I had it correct, but
|Notes keeps burping back that I'm missing and argument, or a bracket, or a
|semi-colon . . . depending on how I've tried to move things around. I'm
|getting frustrated and would greatly appreciate it if someone could look at
|the following code snippet and tell me where I'm fouling things up.
|

|@If( (Company <> "") ; @Success ;


|@Failure("Some Warning") )
|

|Like I said except for the field name and the quoted text, it appears
|identical to the example I am referring to, but Notes doesn't like it. It
|always points to the last couple of characters for the error if that helps.
|

"There are only two kinds of artists: the plagiarists and the revolutionaries."

-- Paul Gauguin

BroncoSaurus

unread,
May 26, 1999, 3:00:00 AM5/26/99
to
OK, my bad . . . I had a default value in the script before the @If
statement. That was causing the problem. When I deleted it . . . all was
well. Thank you to everyone who helped!
Scaba wrote in message
<27DAE693080FB922.E8A1E8B9...@library-proxy.airnews.ne
t>...

BroncoSaurus

unread,
May 28, 1999, 3:00:00 AM5/28/99
to
Nope, I don't . . . but thanks for the advice. I'm sure it will come in
handy as
I go about destroying this database in the future. <g>

Tony Landi

unread,
May 28, 1999, 3:00:00 AM5/28/99
to

BroncoSaurus ha scritto nel messaggio ...

>I'm trying to set up a validation formula to make a field a "required
entry"
>field. I referred to page 352, in PCWeek's "Guide to Lotus Notes/R4" and
>attempted to copy the syntax used there. I thought I had it correct, but
....

>
>@If( (Company <> "") ; @Success ;
>@Failure("Some Warning") )
>
try this:
@If( (Company != "") ; @Success ;
0 new messages