Suppress Datawindow Error Message at runtime

Sylvia

unread,

Nov 15, 2007, 11:02:17 AM11/15/07

to

"Expression not valid" - "Expecting String"
Can these messages be suppressed at runtime?

Jerry Siegel [TeamSybase]

unread,

Nov 15, 2007, 11:14:49 AM11/15/07

to

Take a look at the ItemError event.
I'd want to know about the error so I could fix it or code for unusable
values.

<Sylvia> wrote in message news:473c6d89.77e...@sybase.com...

Chris Pollach

unread,

Nov 15, 2007, 11:19:06 AM11/15/07

to

Along with Jerry's suggestion (which is right on the money) - I would also
note that you might like to code the DBError Event to suppress error
messages there if a Retrieve / Update problem is encountered.

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
news:473c7079$2@forums-1-dub...

Jerry Siegel [TeamSybase]

unread,

Nov 15, 2007, 11:43:45 AM11/15/07

to

Or at least make the message user-friendly.
I didn't think of that because that code has always been in the ancestor DW
object of the framework.

"Chris Pollach" <cpol...@travel-net.com> wrote in message
news:473c717a@forums-1-dub...

Chris Pollach

unread,

Nov 15, 2007, 12:10:14 PM11/15/07

to

"User friendly" - what a concept <bg>!

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message

news:473c7741$1@forums-1-dub...

Sylvia

unread,

Nov 15, 2007, 2:33:17 PM11/15/07

to

Will the ItemError event capture a error generated by a
Filter() of the datawindow?
Thanks for the help :)

Chris Pollach

unread,

Nov 15, 2007, 2:53:00 PM11/15/07

to

Sylvia;

A great question and ... the answer is NO.
You will need to make sure that you ...

1) Check the RC of the Filter ( ) command
2) Code the "Error" event to trap a worst case scenario.

Regards ... Chris

<Sylvia> wrote in message news:473c9efd.7e4...@sybase.com...

Jeremy Lakeman

unread,

Nov 15, 2007, 5:52:02 PM11/15/07

to

On Nov 16, 5:53 am, "Chris Pollach" <cpoll...@travel-net.com> wrote:
> Sylvia;
>
> A great question and ... the answer is NO.
> You will need to make sure that you ...
>
> 1) Check the RC of the Filter ( ) command
> 2) Code the "Error" event to trap a worst case scenario.
>
> Regards ... Chris
>

> <Sylvia> wrote in messagenews:473c9efd.7e4...@sybase.com...

> > Will the ItemError event capture a error generated by a
> > Filter() of the datawindow?
> > Thanks for the help :)
>
> >> "User friendly" - what a concept <bg>!
>
> >> "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
> >> wrote in message news:473c7741$1@forums-1-dub...
> >> > Or at least make the message user-friendly.
> >> > I didn't think of that because that code has always been
> >> > in the ancestor DW object of the framework.
>

> >> > "Chris Pollach" <cpoll...@travel-net.com> wrote in

> >> > message news:473c717a@forums-1-dub...
>
> >> >> Along with Jerry's suggestion (which is right on the
> >> money) - I would >> also note that you might like to code
> >> the DBError Event to suppress error >> messages there if
> >> a Retrieve / Update problem is encountered. >>
> >> >> "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
> >> wrote in message >>news:473c7079$2@forums-1-dub...
> >> >>> Take a look at the ItemError event.
> >> >>> I'd want to know about the error so I could fix it or
> >> code for unusable >>> values.
>
> >> >>> <Sylvia> wrote in message
> >>news:473c6d89.77e...@sybase.com... >>>>
> >> "Expression not valid" - "Expecting String" >>>> Can these
> >> messages be suppressed at runtime? >>>

dw_1.Object.DataWindow.NoUserPrompt='yes'

Sylvia

unread,

Nov 16, 2007, 8:43:22 AM11/16/07

to

Ok, I'm with you on that but that leads me to another
question (sorry :( ).

IF my setfilter() and filter() methods are returning a '1'
and I still get an invalid expression error what would you
theorize the problem to be?

Jerry Siegel [TeamSybase]

unread,

Nov 16, 2007, 8:56:01 AM11/16/07

to

The usual suspects are null values. I'd look at validation and computed
field expressions as well as the filter.
Wild guess: are you using relative or absolute row references - a number in
[ ] after the column name?

<Sylvia> wrote in message news:473d9e7a.15d...@sybase.com...

Sylvia

unread,

Nov 16, 2007, 9:41:02 AM11/16/07

to

Thank you :)
No, I'm not referencing relative or absolute rows.

But, I am referencing columns built at runtime in a crosstab
datawindow.

It doesn't matter if I reference the column name or number,
I get an invalid expression message.

Maybe I can

Andreas Holz

unread,

Nov 16, 2007, 9:46:45 AM11/16/07

to

Did you try an expression like '1 = 1' and are you still getting an
error and returnvalue of 1?

Andreas

> From - Fri