Once again, youreka, or EUREKA Tom!
There was no indication that the problem was inside the loop, just the
query wouldn't work.
In fact it ran perfectly fine yesterday!...? (Though I am going to go
back and check it now.)
Thanks. I know better but... You can bet I won't make that one again
Ralph Smith writes:
> Within the function I have:
> for darec in select * from purchbt where addr not like ''%STE%STE%'' and
> addr not like ''%STE%STE%STE%'' and (addr similar to
> ''%STE[A-Z]*[0-9]+'' or addr similar to ''%STE[A-Z]*[0-9]+[A-Z]'' or
> addr similar to ''%STE[A-Z]*[0-9]+[A-Z][
Within the function I have:
for darec in select * from purchbt where addr not like ''%STE%STE%'' and
addr not like ''%STE%STE%STE%'' and (addr similar to
''%STE[A-Z]*[0-9]+'' or addr similar to ''%STE[A-Z]*[0-9]+[A-Z]'' or
addr similar to ''%STE[A-Z]*[0-9]+[A-Z][A-Z]'') loop
and it finds n