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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Unique index problem
Problem resolved! The error was in the STR(JNUMMER) in the index key - this makes variable length index keys and xBase can't handle that (I even tried to do the above in Clipper code and got the same errors). Changing it to STR(JNUMMER,10) solved the problem. Somewhere deep in my memory I...- JanDoggen
- Post #2
- Forum: dBASE Inc.: dBASE
-
Primary Key
I would say SET UNIQUE ON then create an index and always handle your database with that index open I'm not sure what dBase does if you try to add a record with the same key. You can try. Bye Jan- JanDoggen
- Post #2
- Forum: dBASE Inc.: dBASE
-
Unique index problem
I have a weird problem in dBase III+ DB structure: Field Field Name Type Width Dec 1 JNUMMER Numeric 6 2 BRIN Character 4 3 PLDATUM Date 8 4 LEERJAAR Numeric 1 5 TICK Logical 1 (set date british...- JanDoggen
- Thread
- Replies: 1
- Forum: dBASE Inc.: dBASE
