Start a new topic

Using single quotes in the Where Filter

anonymous

started a topic almost 18 years ago

[This topic is migrated from our old forums. The original author name has been removed]

This may be a DB2 problem only: when using a string containing a single quote in the input field for the Where Filter on the Table/Data view it should be doubled to avoid an SQL syntax error. (DBVis 5.1.1)

e.g. an input of  Sam's Bar
should become  LOCATION = 'Sam''s Bar'

Greetings,
   Gerd.

1 Comment

Roger Bjärevall

said almost 18 years ago

[This reply is migrated from our old forums.]

Re: Using single quotes in the Where Filter

Gerd,

I'll add this to the feature request list.

Thanks!

Regards

Roger

How can we help you today?

Using single quotes in the Where Filter

anonymous

Roger Bjärevall