>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!!!!

Put this before calling the NewID procedure:
SET DATABASE TO MyDbc