Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling an API from a trigger
Message
 
 
À
30/03/2003 11:53:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00771829
Message ID:
00771836
Vues:
17
This message has been marked as the solution to the initial question of the thread.
Hi Sylvain,

If you have a way to check if function is running from application or not, than you can DECLARE API functions in stored procedure as needed. You can also consider using WSH to generate GUID as shown in Re: Smallest GUID Making Code Ever Thread #638458 Message #638589. In VFP7 you can check if DLL is alreday loaded by using ADLLS() function.

>I am using GUIDs as PK for my tables. I have a stored procedure that return a GUID. This function is used as the default trigger for the PK.
>
>The problem is that the stored procedure use API functions to generate the GUID and that these API functions need to be declared before calling them. I don't want to restrict the use of the database only through an application, I want to be able to open up the table in VFP and append new records directly and have the PK generated by default.
>
>Is there a way to make that happen? I am using VFP 6.0
>
>TIA
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform