Garbage after statement

[francisvandergr]

OpenstaandOrders:

load

Factuurnummer,

Crediteur,

Cred\Openstaand,

Ordernummer,

Factuurdatum,

BedragVV,

Koers,

teller,

artcode,

Valcode,

Ontvangenbedrag as Bedrag,

Cred

Resident Crediteuren_tmp where Ontvangenbedrag is null;

When i have this script i get a message: garbage after statement.  I want to have al records from the table Crediteuren_tmp where the field Ontvangenbedrag is empty

[#2 · Accepted solution]

Hi,

change "where Ontvangenbedrag is null;" with "where IsNull(Ontvangenbedrag);"

Hope this helpes!

Stefan

[francisvandergr]

Thanx it works.

Gr

Francis