kliao

FileMaker 9 I haven't seen this answer anywhere, but think this is the right forum to ask. I have solutions that exist in two places - a dev server and a live server. Some of these solutions use the data separation model. I usually fix bugs and write new features in the dev server, then post to the live server during scheduled downtime. However, the user accounts are not in sync. The solutions contain a mix of externally-authenticated accounts and internally-created FileMaker accounts. Obviously, I'm not worried about the external accounts. Is there any way to transfer the FileMaker accounts from one solution to another, such as from live to dev? TIA ken

I have this following situation in a FileMaker file: 1. User searches for and finds records in Table A. 2. User clicks a button in record row a1. This button is attached to script s1. 3. Script s1 has two branches: a. If there is a related record in Table B, script goes to this related record. b. If there is no related record in Table B, script creates a new related record, then goes to it. 4. User winds up in record b1 and layout b1 in Table B. How can I code this behavior in PHP? I get error 101 - Record is missing. I have this form snippet for page A. I have this PHP snippet for page B. $newPerformScript = & $fm->newPerformScriptCommand(myLayout, myScript, myParameter); $result = $newPerformScript->execute(); ExitOnError($result); I'm guessing I need to tell $newPerformScript to read the value of keyProjectID, but I'm not sure how/where to insert it. TIA, ken

I was afraid of that. Thanks, Corn.

Corn, thanks for the reply. However, I want to use ExecuteSQL, leveraging the server's ODBC connection, instead of using ESS. Unless I missed something completely, the current state of FM9Server can't let me do this?

I have an FM9 solution hosted with FileMaker Server 9 Advanced on a Windows Server 2003 platform. As such, I set up an ODBC connection on both my dev box and server box to an internal Oracle database. The Oracle table I wish to connect to contains over 700K records, so ESS is very slow. I'd like to execute SQL queries instead. The SQL queries I wrote on my dev box run correctly. When I connect to the server version of the FM database, the server's ODBC connection is not available, so the queries don't run at all. Can FM9 Server not use the server box's ODBC setup? I'd rather not set up individual ODBC connections for the hundred or so users. TIA ken