@wquery name matches multiple conditions

[troy_walters]

I want to wquery a database to find all object whose name matches "AUBPSF?????.a" but not "AUBPSF??000.a".

I can do this with no problem using the query functionality in the GUI, putting

name matches "aubpsf?????.a and not aubpsf??000.a"

in the WHERE field, but I need to do this programmatically.

I have tried:

Code: Select all

string tt = @wquery("acperm", "name matches "aubpsf?????.a and not aubpsf??000.a"") but this throws an error because of the nested double quotes.

I have tried:

Code: Select all

string tt = @wquery("acperm", "name matches aubpsf?????.a and not aubpsf??000.a") but this throws an error because of the ambiguity of the and operator.

Is there an escape character for strings, or am I going about this the wrong way? Thanks.

[EViews Jason]

try

Code: Select all

string tt = @wquery("acperm", "name matches aubpsf?????.a and not name matches aubpsf??000.a")

[troy_walters]

That did it. Thanks!