I have a STORED PROCEDURE I use called NEWID for creating unique ID's when a DB record is added. It is in the DEFAULT VALUE of the Table Designer for the ID field as NEWID(). I also want to use it for creating another unique ID when needed for clients. I wrote the code as follows in the SAVE button on my form...
custnum=newid(FirmId)
FirmID is a unique ID # that NEWID uses for getting the appropriate NEXT number for use.
The above works in the development environment fine when I run the form with the code. I assumed it was working fine. When I ran the SETUP wizard and created the diskettes, when adding records normally (using the DEFAULT VALUE) it works fine. When I call it with the above code executable version of the program gives the following error..
Error: 1
Program NEWID not found
Why??? Am I not calling the FUNCTION correctly? Do I not have it in the proper place? Where should this reside and how do I access in both instances.
HELP!!!!
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!