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
