NN_ fields from btrieve

[Tamina]

I'm using direct connection to a btrieve database and there's a problem with 2 tables. All the field-names are shown twice: once normally, and second time field-name gets a prefix NN_. So the table looks like this:
field_name1
NN_field_name1
field_name2
NN_field_name2
...
When I try browsing on that NN_ field, I get database error Btrieve[62]:Incorrect descriptor.
Did anyone have this problem before? Why is this happening?
Thanx.

 

[kenhamady]

This sounds like you have a corrupted DDF file. If you ignore these fields do the reports work OK? What if you verify the database, do they still appear this way? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[Tamina]

The reports used to work ok, except once I had a report that was repeating each record from "strange" table twice (I'm trying to simulate that behaviour again).
When I connect using ODBC, fields look fine.
If I verify the database, everything remains the same.

?!?

 

[Tamina]

It looks like something is really wrong with field.ddf - those field-names appear there, too. I'll try to fix it somehow.
Thanks for helping.

 

[kenhamady]

duplicate field names and duplicate records are a completely different issues (rows vs columns). No matter which DDF you use (File, Field, Index) all three are used aa a group. Good Luck. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com