Hi Nadya,
Thanks for the coding tip.
I think I found my problem. The DBF is named AGENCY.DBF and the first field in the DBF is named AGENCY Char 2. When I got the error and went into debugger and looked in the LOCALS window I saw AGENCY was TYPE "O" for object. It did not list the field AGENCY as TYPE "C" for character. This must be why I get the data type mismatch error. Also, AGENCY field is one of the indexed fields.
Now I have to figure out how to get around it without changing the names of the DBF or the field because many apps use the AGENCY DBF.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.