Hi ,

I am trying to write query extension where ( "tfacr200.ttyp <> "C02""). But the sesions returns error please help.


Thanks in advance.

regards,

George

The code is

query.extend.where("tfacr200.trec = tfacr.trec.assignment or tfacr200.balc = tfacr200.amnt " )
"or tfacr200.ttyp <> " & ttyp1 & " or tfacr200.ttyp <> " & ttyp2 & ")"

Define a string variable for your query extension and fill it. Then use this variable in the query.extend.where() function

Examle:

string extension.string(256)

extension.string = "tfacr200.trec = tfacr.trec.assignment or tfacr200.balc = tfacr200.amnt or tfacr200.ttyp <> " & ttyp1 & " or tfacr200.ttyp <> " & ttyp2
query.extend.where(extension.string)