I don't have it with me here but you can do it by calling a xSLT
which if you have advanced and XSLT publishing on will call a script.
let me see if I can get someone to send me one.
Dan
On Jul 24, 2007, at 6:44 PM, Kent Swisher wrote:
Ooops, I forgot FMPSA8 can't run scripts on the server. Will have
to find some other way.
-> Kent
On 7/24/2007 3:32 PM, Kent Swisher wrote:
I am attempting to call a stored procedure (script) on Filemaker 8
server advanced (windows) via Witango (windows) direct dbms
action. Using ODBC drivers.
Found an old post in the archives showing the format for calling a
stored procedure for Filemaker 6 was of the form below.
CALL stored procedure (a script) statement
{ CALL script_name ( database_name [ ,
{ layout_name | password } ] ) }
Where the outermost curly brackets { } are part of the CALL statement
syntax.
I have not had any success with this. Since ODBC to FM 7 and
above don't know about layouts, I suspect this is part of the
problem.
Has anybody gotten stored procedure calls to FM7 to work? If so,
example of the syntax please. Dan Stein asked the same question
in 2004 but no solution was posted.
FM8
Witango 5.5
Windows Server 2003
-> Kent Swisher Engineering Tools
-> Alcatel-Lucent Application Support Engineer
-> Wireline Access Products [EMAIL PROTECTED]
-> Petaluma, CA 707-792-7116 (on net 2-855-7116)
_____________________________________________________________________
___
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
