>Bob is absolutely right, I was talking about extended stored proc.
>
>Sometimes, when I type, I think I reproduced what was in my mind but it's often not the case! Sorry 'bout that.
>
>So basically, I have to do this in C, no way around this?

Or C++... you may be able to do it in Delphi. Anything that creates a C based API dll. See SQL Books Online topic: Creating Extended Stored Procedures

BOb


>
>Thanks,
>
>SC
>
>>>Bonjour Stephane,
>>>
>>>A) SQL store procedure must be writting in SQL syntax.
>>>
>>>B) From within a VFP program you can use a SQLTransac to do anything including deleting and creating a store procedure.
>>>
>>>HTH
>>
>>He's talking about "extended" stored procedures.
>>
>>BOb