Start a new topic

Using single quotes in the Where Filter

[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

[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