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