Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual FoxPro
Expertise: Beginner
May 9, 2000

Creating a Primary Index with Filter via Code

Question:
On the Indexes tab of Visual FoxPro Table Designer dialog, you can define a Primary Index. How do I do the same thing through code in a FoxPro program?

Answer:
You need to use the ALTER TABLE command. What follows is the code to create a database called bobo with a table called mydbf, with a primary key called cName:

CREATE DATA Bobo
create table mydbf (cName C(10),nAge N(3))
ALTER TABLE MYDBF ADD PRIMARY KEY cName TAG cName
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap