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)