Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Filemaker Stored Proc Datadirect Driver
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Filemaker Stored Proc Datadirect Driver
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01582985
Message ID:
01582985
Vues:
35
How to call a Filemaker Stored Proc from Visual Foxpro using ODBC

Driver used: Driver={DataDirect 32-BIT SequeLink 5.4}

I've integrated a Visual Foxpro application with a Filemaker application.

I can access Data from the Filemaker Database using the Visual FoxPro SQLEXEC()

Lately, I've tried to trigger Stored Procedure in the Filemaker Database without success.

Here is the syntax that I used: The name of the stored proc is 'test' (No caps)
llResult = SQLexecute(lnHandle ,'test')
llResult = SQLexecute(lnHandle ,'test()')

llResult = SQLexecute(lnHandle ,'{test}')
llResult = SQLexecute(lnHandle ,'{test()}')

llResult = SQLexecute(lnHandle ,'call test')
llResult = SQLexecute(lnHandle ,'{call test}')
llResult = SQLexecute(lnHandle ,'{call test()}')

llResult = SQLexecute(lnHandle ,'exec test')
llResult = SQLexecute(lnHandle ,'{exec test}')
llResult = SQLexecute(lnHandle ,'{exec test()}')

Here are the result I've got:
test
1526
Connectivity error: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
[DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
S1000
-201
1
.NULL.
--------------------------------------------------------------------------------
test()
1526
Connectivity error: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
[DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
S1000
-201
1
.NULL.
--------------------------------------------------------------------------------
{test}
1526
Connectivity error: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
[DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
S1000
-201
1
.NULL.
--------------------------------------------------------------------------------
{test()}
1526
Connectivity error: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
[DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
S1000
-201
1
.NULL.
--------------------------------------------------------------------------------
call test
1526
Connectivity error: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
[DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
S1000
-201
1
.NULL.
--------------------------------------------------------------------------------
{call test}
1526
Connectivity error: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver]The statement contained an escape clause not supported by this database driver.
[DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver]The statement contained an escape clause not supported by this database driver.
S1000
0
1
.NULL.
--------------------------------------------------------------------------------
{call test()}
1526
Connectivity error: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver]The statement contained an escape clause not supported by this database driver.
[DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver]The statement contained an escape clause not supported by this database driver.
S1000
0
1
.NULL.
--------------------------------------------------------------------------------
exec test
1526
Connectivity error: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
[DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
S1000
-201
1
.NULL.
--------------------------------------------------------------------------------
{exec test}
1526
Connectivity error: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
[DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
S1000
-201
1
.NULL.
--------------------------------------------------------------------------------
{exec test()}
1526
Connectivity error: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
[DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
S1000
-201
1
.NULL.
--------------------------------------------------------------------------------


Please let me know if you've manage to call a Filemaker store proc or if there is a different syntax available.
I've worked with MS-SQL, ORACLE and did not have any issue calling Stored Proc.
Luc Nadeau
lnadeau@neova.ca

"the theory, it is when all is known and that nothing works. The practice, it is when all works and that nobody knows why." - Albert Einstein (Nobel of physique 1921)
Répondre
Fil
Voir

Click here to load this message in the networking platform