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
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
126
Rosciano
Rosciano
Halfthumb
  • Locked
  • Question
PRIMARY KEY
Replies
0
Views
25
Halfthumb
Halfthumb
jgood4u
  • Locked
  • Question
Using "ON KEY" to close a BROWSE window in IV 2.0 1
Replies
2
Views
42
jgood4u
jgood4u
kmfna
  • Locked
  • Question
Automatically Generating Keys
Replies
1
Views
41
craigsboyd
craigsboyd
bigroger
  • Locked
  • Question
Fuction Keys to activate Control-End
Replies
5
Views
79
dbMark
dbMark

Part and Inventory Search

Sponsor

Back
Top