Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
This is not recommended, but can I get away with it?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
This is not recommended, but can I get away with it?
Miscellaneous
Thread ID:
00672392
Message ID:
00672392
Views:
36
I have a DBF named Agency
In the Agency DBF...
I have a field named Agency
I have an index named Agency

After I SCATTER MEMVAR MEMO and THISFORM.Refresh
I get the error Data Type Mismatch.

The Locals Window shows Agency as OBJECT
The Locals Window does not show Agency as CHARACTER FIELD.
That causes the error Data Type Mismatch. I proved this when
I renamed the Agency field to Agency _ID and the error disappeared.

Is there any way I can use the same name for a DBF and a field and an index? I know it's not good practice or it may be illegal, but so many applications use the Agency DBF that changing the field name would cause an avalanche of changes in other projects and forms.

Any way to get this to work without changing the field name? Thanks for your ideas?
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Next
Reply
Map
View

Click here to load this message in the networking platform