Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use UDFs function from FireBird in VFP
Message
From
11/09/2008 14:14:27
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to use UDFs function from FireBird in VFP
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01346742
Message ID:
01346742
Views:
76
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

TIA

Benoit
Next
Reply
Map
View

Click here to load this message in the networking platform