Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
change "where Ontvangenbedrag is null;" with "where IsNull(Ontvangenbedrag);"
Hope this helpes!
Stefan
Hi,
change "where Ontvangenbedrag is null;" with "where IsNull(Ontvangenbedrag);"
Hope this helpes!
Stefan
Thanx it works.
Gr
Francis