MichelVerhaegen
26th February 2007, 11:26
Hi,

Can someone help me with the script of a condition in the session tuxch0131s000.

I have to find the records where the condition of the selected field is "empty"

if tfacp240.ladt = "empty" then ....

What do I have to put in place of "empty"

Michel

norwim
26th February 2007, 13:34
Hi there,

although I never use exchange (I prefer bdbpre and bdbpost), I guess that the type of field matters, for a string I would try "", for numeric values (including date fields) I'd rather expect a 0 or 0.0 (for double) to do the job.

hth

Norbert

Hitesh Shah
26th February 2007, 17:29
The field seems to be of date type. In that case u can write ladt = 0 .

If it is on the form u can use less than condition for date 01010001 .

For enum field u should be able to use word 'empty' or ltoe(0) in condition text