Daniel C

Great, thanks for the info Rick. I will do that.

Hi Everyone, We are about to upgrade our server from 13 to 14. In the FMS 14 getting started guide it states: "Make a copy of any database files and shell script files you used with FileMaker Server." and gives the database location: "\Program Files\FileMaker\FileMaker Server\Data\Databases" ​My question is do we need to make a copy of the other contents in this folder, namely "RC_Data_FMS" with all of the externally stored container data? Moreover, after we uninstall 13 and install 14 will we have to move it back to the same location? The guide only mentions database and script files so I was unsure what needs to be copied. Thanks for your help. Daniel

Hi Everyone, I have an animated GIF (spinner icon) in a web viewer that I display while running a script to show the system is busy. One of the script steps inserts a file as a reference. This step takes about 5 to 10 seconds to complete. I have noticed that if the file path uses an address with a mapped drive it is much quicker than a UNC address, unfortunately I need to use a UNC file path. When the script gets to the insert file as reference it stops the animated gif and causes the web viewer to go blank until the insert file step completes. Any ideas on a fix to keep the GIF animated while the insert file as reference completes or any other solutions? Thanks for your help Daniel

Hi, I have the following ExecuteSQL statement which selects the highest document number from the control table based on a given type. The statement is: ExecuteSQL ( "SELECT Max(DocNum) FROM Control WHERE Type=?";"";"";Control::Type) This works fine. I have a second table called "Obsolete" that has the same field "DocNum". I would like to get the the Max of DocNum from both tables. I tried just adding Obsolete to the the FROM statement but that did not work. I am new to SQL, any help is greatly appreciated. Thanks. Daniel

Thanks comment. I don't know how I missed this. I converted my input value to decimal, added 1 and used your custom function. Thanks again.

Hi, I am not sure if this needs to be a custom function or just a calculation but I am trying to increment a field with a letter in it. I have found a function to increment through the alphabet which is what I need but after "Z" I need to go to AA->AB->AC...AZ->BA and so forth. The original topic with the calculation is here: http://fmforums.com/forum/topic/32866-increment-the-alphabet/ Thanks for any help. Daniel

Thanks Wim. This definitely points me in the right direction. I will just have to figure out how to convert the macro to VBS.

Hi, I am currently working on a FileMaker document management solution and adding and removing watermarks is a requirement of the process. The documents are office documents mainly Word and Visio and will be kept in container fields within the solution. Right now the best i have come up with is a send event script with the CMD code: start winword FilePath /mmacroname This opens the word document and calls a macro that removes or adds a watermark and closes the file. This works OK for word but I have not been able to find a CMD equivalent for Visio that lets you call a macro. Furthermore, this solution will be hosted on FileMaker server so all users would have to have macros enabled. I am looking for another way of doing this or a plug in that could accomplish or help with the task. Any help or ideas are greatly appreciated. Thanks. Daniel