Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dbf vs db secondary index

Status
Not open for further replies.

harrymossman

Technical User
Sep 5, 2002
255
US
We are in Paradox 9. We have a complex Pdox form that includes UTM.DB, a table of UTMs (Universal Transvers Mercators - similar to latitudes and longitudes).

The GIS folks would like for that table to be in dbf format so they could use it directly in ArcGIS without having to convert it.

The table has a primary index number plus a secondary index called LogNum, which is composed of two fields, one numeric and one alpha.

When I try to convert UTM.DB TO UTM.DBF, I get "Error copying index LogNum", "Complex indexes not allowed in dBASE tables."

I restructured UTM.DBF to include a LogNum index. But I can't link it to the main table in the form. The LogNum index doesn't show up.

What can I do to deal with this (other than just telling the GIS people they have to convert each time they want to use the table.)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top