for each question !

[make]

Hi there,

i made a for each query like this :
for each month
where .....
no-lock.
Do this...... with month. .....
....
....
end.

Now i have the Problem, that i have to check if some of the fields in the month table are empty.
How can i do that ?
When this case happens the procedute should do not nothing!

Greets
make

 

[Henri de Vos]

for each month where .... no-lock:

if month.field1 = empty or month.field2 = empty then next.

do something with month.

end.

If you want to update fields you should replace no-lock with exclusive-lock.