Jump to content

Garry Claridge

Members
  • Content Count

    2,829
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Garry Claridge

  • Rank
    member
  • Birthday 11/25/1954
  1. What happens if you do a "Refresh Window" from the "Records" menu? Do this straightaway after the "New Record" action. This is to check if it is a problem with FM just not re-displaying quickly. If that is the case you may want to create a new record using a Script containing the "Refresh Window" step. All the best. Garry
  2. I firstly perform an FM Script (Export) then a System script. I am receiving a Status of "system script error" whenever my schedule runs! Even though the shell script performs fine when run from the Terminal. The shell script is just the "mysqlimport" command (with appropriate parameters). I have checked the Execute permissions of the mysqlimport command and all have execute rights. Any thoughts?
  3. Thanks Steven, I did read your article prior to writing the Script (Thank you). This is what I read: "...resolves to the Documents Folder in the root level of FileMaker Server...". The structure in the /Library/Filemaker Server/ directory looks like this: / Admin Common Data Database Server Desktop Documentation Documents Examples ..... To me the "Documents" directory here is at the "root" level of the FMS. However the path resolves to: /Library/Filemaker Server/Data/Documents as shown here: / Admin Common Data - Backups - Databases - Documents - Scripts Database Server Desktop Documentation Documents Examples .... Well that is how our install resolves with FMS 10. All the best Garry
  4. I was caught by a "gotya" with this today. The "Get(DocumentsPath)" is to "/Library/Filemaker Server/Data/Documents". I was looking for the file in: "/Library/Filemaker Server/Documents". Hope this helps somebody : Garry Claridge
  5. Has anybody found a way to workaround the fact that all fields are "Required" and not able to be changed in the EDS tables? I have had this problem with both MS SQL and MySQL. Thank you.
  6. Sounds like a Trial version to me also! Good Luck. Garry
  7. Another method may be to use a PHP script on the hosting server as "go-between". The PHP script can return purely text data that FM can do something with??? Good Luck.
  8. Remove the "ServerDataSource" from the ini file. All the best. Garry
  9. Got it : In the "Calculated SQL" I can use double quotes " around database objects; i.e. Table and Field names. Hence the FM calculation may look like this: "INSERT INTO "Web Long Description" ("Item No_",...... Garry
  10. Does anybody know how to get around the problem of accessing tables with names containing spaces? Usually, I would use ` character to delimit the name, however this does not seem to work with "Execute SQL". I cannot change the table names as it is Microsoft Dynamics : Thank you. Garry
  11. I've been successfully inserting into a MySQL database via Scripts without using "Commit". However, not too sure about using "Set Field" directly after the INSERT. Good Luck. Garry
  12. If you use a "Button" to go between Layouts you could use that Script. You may be able to prevent the Users from using the Layout Menu, and hence bypassing the Button, by removing the Layout from the Layout Menu. Good Luck. Garry
  13. If you are using a Mac you may be able to use AppleScript to load the file list into a table. The AppleScript may be able to be run as a Service and listen for an Event whenever the contents of a Folder is changed. Thus updating the table. This is only a guess. Good Luck. Garry
  14. You can also use ODBC for INSERT, UPDATE and DELETE via the "Execute SQL" Scriptmaker step. All the best. Garry
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.