>Hi all
>I have to update some Firebire Table with my Vfp app.
>I use sqlexec like this
>
>TEXT TO lStrReq NOSHOW ADDITIVE TEXTMERGE PRETEXT 7
> INSERT INTO ETABL(ID_ETABL,NOM,VILLE) VALUES(0001,'HOP VETERINAIRE','QUEBECC')
>ENDTEXT
>
>lnOk = SQLEXEC(tnConn,lStrReq)
>lCom = SQLCOMMIT(tnConn)
>
>If the table dont use udfs function i can add the data but i try to update another table an i got this message
>
>Statement #1:
>invalid request BLR at offset 31
>function SOUNDEX2 is not defined
>module name or entrypoint could not be found
>
>How can i define the soundex2 function

There is no SOUNDEX2() function in VFP. Is there one in FireBird? Is that what you're trying to use?

I'm not familiar with FireBird. Do you have to somehow "load" the SOUNDEX2() function to make it available to the database server process - maybe it isn't by default?

Does the FireBird ODBC driver support calls to local FireBird functions/UDFs?