Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling an API from a trigger
Message
 
 
To
30/03/2003 11:53:48
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00771829
Message ID:
00771836
Views:
19
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform