All important things to rememeber. especially good advice to read the
docs a must.
If you are going to use ODBC the best way to handle this is to create
an empty file and pull in the tables from your data file into the
empty file TO. That way you can just have base tables to act on for
ODBC.
Depending on what your script does you can also run it from this file.
If you want to contact me back channel next week I can help you.
Dan
--
Dan Stein
FileMaker 7 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
FMP, WiTango, EDI,SQL 2000, MySQL, CWP
[EMAIL PROTECTED]
www.dss-db.com
"The love of one's country is a splendid thing. But why should love
stop at the border? "
Pablo Casals
On Jul 25, 2007, at 9:32 AM, Beverly Voth wrote:
That's good advice, and Kent, you might understand that "layouts"
are now
tied to the "table occurrence" (as it appears in the relationship
graph) and
NOT the tables (although these could have the same name). ODBC calls a
particular Table Occurrence, not any given layout. Table
Occurrences, can be
based on related data, so you can think of them as "stored procedures"
already. Or Table Occurrences can show the raw table of data.
I never tried "CALL" with FileMaker ODBC, but you might take a look
at the
documentation on serving FMP with ODBC and see what is allowed.
Also, the
driver documentation you use may give you other clues to what is
allowed.
Remember, too, that "password" is no longer the only way to access a
database. You have a user AND password (unless you omit the
password, but I
doubt you'd do that!!)
You can make HTTP requests to XML (as Dan suggests) and have -
script as part
of the call. XSLT may or may not be needed.
--
Beverly Voth Tier3 Data & Web Services Group, LLC
606-864-0041 http://www.tier3web.com/xml.htm
Certified FileMaker 7 Developer * FileMaker Business Alliance
Web Design & Hosting
Coldfusion, Witango, PHP, MS SQL, MySQL, FMP, XML/XSLT, CSS
Over 12 years experience integrating databases and the internet!
On 7/24/07 7:59 PM, "Dan Stein" <[EMAIL PROTECTED]> wrote in whole or
in part:
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
