dbase filter

[imageres]

I have written the following dbase expression intended to find all contact records containing A Detail that has either the letters "NES" or "UES" in the first three possition of the Reference field of the Detail. When using the GM dbase expression tester I get no errors but the expression just is not doing what I think that it should - any ideas??

substr("contsupp->contsupref",1,3)= "NES".OR. substr("contsupp->contsupref",1,3)="UES"

Thanks Doug

 

[philhege]

I'm a bit rusty on the dBASE expressions, Doug, but shouldn't the field references be referential? It looks like you're comparing the literal string "contsupp->contsupref" (NOT its contents) to the strings you're looking for.

Another thing to try is to switch to the SQL view of the filter and see what it comes up with.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[goner]

try LEFT instead of substr?

Doug Castell
Castell Computers
(310)601-4738

http://www.castellcomputers.com