Logical expression OR on Form propertis

IvonaK

Hi to all,

Is there any possible way to put on SourceTableView on Form propertis two conditions associated with logical expression OR.
for example (Field1='A') OR (Filed2='B');

Any advice
Thanks a lot,

sourav_ait

Not possible through sourcetableview. You can not have contradictory condition with in it. Try using some coding on Onopen() trigger of the form.

tinoruijs

No, that's not possible.
To achieve this, you must mark records which you want to show and then open the form.

IvonaK

Thanks a lot.

jlesage

you could set SourceTableTemporary to Yes
then in onOpenForm select the record needed


Item.RESET;
IF Item.FINDSET THEN
REPEAT
IF (COPYSTR(Item."No.",1,1) = '0') OR
(COPYSTR(Item.Description,1,1) = 'A') THEN BEGIN
REC := Item;
INSERT;
END;
UNTIL Item.NEXT = 0;

If the table is not too big.

IvonaK

Thanks a lot.