Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling stored procedures or functions????
Message
From
19/08/1999 22:25:39
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Calling stored procedures or functions????
Miscellaneous
Thread ID:
00255679
Message ID:
00255679
Views:
51
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!!
Next
Reply
Map
View

Click here to load this message in the networking platform