newbie reporting question

mbosveld

I am trying to fill a field in the Customer table.
It is a boolean field.

What will be the code to do so. I tryed a lot of things already but it doesn't work. The field name is fBlnShowDiscountOnInvoice.

Please help me out. I am a complete newbie at reporting.

kriki

fBlnShowDiscountOnInvoice := TRUE

or

fBlnShowDiscountOnInvoice := FALSE

mbosveld

Yes, but what is the code to change the field.
something like
IF fBlnShowDiscountOnInvoice = FALSE THEN recfBlnShowDiscountOnInvoice.MODIFY := TRUE

I Tried this but it doen't seem to work.

kriki

I don't understand exactly what you mean. But I'll give it a try.

To change the value from TRUE to FALSE or vice versa:

fBlnShowDiscountOnInvoice := NOT fBlnShowDiscountOnInvoice;

Once you put some value into the field, you have to save it's record (if the field belongs to a record).

MODIFY(FALSE)

to NOT trigger the OnModify-code of the table
or

MODIFY(TRUE)

to trigger the OnModify-code of the table

I hope this answers your question

mbosveld

Thank you, this works perfectly.