devxlogo

Creating a New ID

Creating a New ID

Why Trust Us

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.

See also  Professionalism Starts in Your Inbox: Keys to Presenting Your Best Self in Email
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
View Author
Show More