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!

Register Log in
  • 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!

Primary Key

Status
Not open for further replies.
demopro

demopro

Programmer
Apr 23, 2001
117
0
0
US
Can dBase have a PK? I need to have just one column set as a PK to ensure that duplicate data does not happen. I am using dBase4.
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Using SET UNIQUE ON will always give you the first unique occurance of a record. Using the COPY TO command will create a table with only those unique records.

Jim C.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Rosciano
  • Locked
  • Question
"ENTER" key -dBase III Plus-
Replies
2
Views
81
Rosciano
Rosciano
Halfthumb
  • Locked
  • Question
PRIMARY KEY
Replies
0
Views
14
Halfthumb
Halfthumb
jgood4u
  • Locked
  • Question
Using "ON KEY" to close a BROWSE window in IV 2.0 1
Replies
2
Views
37
jgood4u
jgood4u
kmfna
  • Locked
  • Question
Automatically Generating Keys
Replies
1
Views
38
craigsboyd
craigsboyd
bigroger
  • Locked
  • Question
Fuction Keys to activate Control-End
Replies
5
Views
69
dbMark
dbMark

Part and Inventory Search

Sponsor

Back
Top