Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling stored procedures or functions????
Message
De
19/08/1999 22:25:39
Peter Brama
West Pointe Enterprises
Detroit, Michigan, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Calling stored procedures or functions????
Divers
Thread ID:
00255679
Message ID:
00255679
Vues:
52
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!!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform