Login | Register   
LinkedIn
Google+
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
Oct 6, 2000

Creating a New ID

Question:
I am new to VFP. I want to create a unique number for a customer ID field in a table. The VFP sample program "tastrade" simply uses NEWID() as the default value for the given field.

When I try the same in a new database I get the error message, "NEWID.PRG does not exist." This is simple to do in Microsoft Access, but I have spent a couple of hours on it already with VFP.

How do I create a unique number when entering new data into a row of a table?

Thank you for your help.

Answer:
NewId works in the tastrade application because it is a stored procedure in the database. For stored procedures to be available, the database that the table is in must be open and be the current database.

To get the code for the NewId procedure, use the MODIFY DATABASE command to open the database used by tastrade. Then open up the stored procedures. You can paste the NewId procedure into the stored procedures of the new database you are creating.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


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

 

 

Sitemap