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