Coding special characters in a aql wizard filter

[Steve3368]

From within a wizard on the Filter of a DBLISTBOX the following is an excerpt of the code (supplied only what needed)

dim ubermodel as string
ubermodel={ReqLineModel.Value}
dim aqlstring as string
aqlstring="Stock.Name = 'Microserve Steady State Storage - Vista' or Stock.Name = 'Microserve Steady State Storage' and fv_QuantityAvailable > 0 and seAssignment=1 and Model.Parent.Parent.Name='"& ubermodel &"'"
Retval=aqlstring

Currently it returns all in the stock in Microserve Steady State Storage - Vista plus the stock from the steady state that is qty >0 and correct model.
This is what I need
aqlstring=" (Stock.Name = 'Microserve Steady State Storage - Vista' or Stock.Name = 'Microserve Steady State Storage') and fv_QuantityAvailable > 0 and seAssignment=1 and Model.Parent.Parent.Name='"& ubermodel &"'"
but with the 2 red brackets as special characters not as text.

The problem is that the brackets or using a Like 'xxx %' need to be treated as special charachters and I can't seem to find the right combination of " ' & and CHAR(39) to make it work right.

Anyone have any ideas?

We are using AC 4.4.0 with a DB2 v8 database

[Artur]

Hi,

I have not used AC for years - but since no one responded, maybe what I remeber will be better then nothing .
Try:
Guess 1: aqlstring=" \(Stock.Name = 'Microserve Steady State Storage - Vista' or Stock.Name = 'Microserve Steady State Storage'\) and fv_QuantityAvailable > 0 and seAssignment=1 and Model.Parent.Parent.Name='"& ubermodel &"'"

Gues 2: look for Unescape function in AC - AFAIR this is for special characters in queries.

Hope That Helps
Artur

[Steve3368]

Thanks. I'll try that.