Mark B

The update came too late (although I was impressed at how fast it came). I had started the uninstall of Java 18 before the update came. As of now, I don't have any Java on my PC and I can't install any new versions. I get the message that it can't find "jre.6.0_10-c.msi". I have downloaded and run JavaRa, removed 'HKEY_CURRENT_USER > Software> JavaSoft' and 'HKEY_LOCAL_MACHINE > Software> JavaSoft' from the Registry, deleted all Java folders in Program Files and Common Files and from 'C:Documents and Settings{user}Application Data. The last message to appear after it looked like it was going to install was "Error 1714. The older version of Java6 Update 18 cannot be removed...". The Java web site has no help for Error 1714. Do you have any ideas? UPDATE: Ignore the plea. I downloaded and ran 'Windows Install Cleanup Utility' and then I was able to install the latest Java. Now Scriptmaster works fine.

Is there a way to automate the conversion of embeded objects (pdf files)in container fields to links only? I'm currently using fmp v6.0 but will be converting to 8.5 this year.

Until I convert to 8.5, I must complete an important project using Version 6.0. I need to calculate biweekly pay dates for employee contracts for a 3 month period, with 1st pay date being the next date in the biweekly cycle after their contract date and "Base Date" is the 1st pay date of the year. I figured that if I use Mod(Contract Date - Base Date, 14) and add that to their Contract date, I would have the 1st Pay date for that employee. I tested the math in Excel and got it to work. I found a problem in Filemaker (V6). The MOD and INT functions give different results from Excel. (Ver 8.5 is fine). FM6: Int(-3.4)=-3, Excel & V8.5: Int(-3.4)=-4. Also, FM6: Mod(48,14)=6, Excel & FM8.5: Mod(48,14)=8. Any workarounds / Suggestions?

Ray, Thanks for the code. I'll give it a try. I have rarely used repeating fields, since I find relationships much more friendly, but this application is a small part of a huge system (>150 open files)and I really didn't want to add to that number for such a trivial audit-trail function. I haven't converted to version 7 because I didn't want to fix the 1000's of scripts that are out there that don't have the same functionality after the conversion as they had before. (I've tried). Mark

I feel this question should have a very simple answer, but I can't find any solutions in several reference books. How do I use a script to insert data into the next empty repeating field? The Repeating Functions seem to be for retrieving data, not inserting new data. Set field doesn't allow for a field value to dynamically set the repetition value. Do I have to set up a loop and manually count each field to find the 1st one that is empty, store that value then do a series of If statements before I can enter the value to a set field with the specific repetition value? (yuk). Mark

This seems like a really stupid question, but I've never worked with container fields before now. Once I have data (photos) in a container field, how do I find records that contain data in a container field?

Does anyone have "inside" information as to when FM will release bug fix v3? I am holding off upgrading our offices until v3 is relased. I can not spend time reprogramming around the Value List bugs. I am making a huge assumption that that bug will be fixed in v3.

After converting 20 files to FM7V2 from FM5.5V2 without any errors (no problems in the log), I am pulling my hair out trying to close/hide windows that I don't think are open trying to get a simple script to work in V7. Following is the script from 5.5 which is run from my "Visits" file. The purpose is to pass values in a "Global" file for reference in a yet to be opened file. (I have read that V7 can do some passing of values somehow, but I haven't played with that yet.) Set Field ["Global Link", "1"] Set Field ["Global::Client ID", "Client ID"] Set Field ["Global::STR1",""""] Set Field ["Global::STR2",""""] etc. The V7 converted script (that doesn't work) follows: Set Field [Visits::Global Link; 1] Set Field [Global::Client ID; Visits::CLient ID] * Set Field [Global::STR1; ""] Set Field [Global::STR2; ""] etc. The * notes the script line that causes the problem. I have tried adjusting, closing or hiding the Visits window with no effect. Every time I try to set a field in Global file from a field in Visits, I get the following error: "This record cannot be modified in this window because it is already being modified in a different window". How on earth (or at least in V7) do I get this stupid thing to work?

Thanks Dan for the unique work-around. My solution is much simpler. I am not upgrading the rest of our PCs to version 7 until this bug is fixed. I have found several more major problems that makes me question how well V7 was beta tested prior to its release. Have you seen this one? If you have a numeric field displayed from another file with a boolian format of "Yes / No", the value (Yes or No)is not displayed until the cursor enters the field. Another problem (that I fixed) is if I have a script that performs an external script, then stops in a field in a portal that has a value list pop-up, waiting for input, the pop-up list does not display. When I exit the script and go to the field, all is ok. What I had to do was add the "Select Window (Current Window)" script step after the external script. My guess is that since V7 can have multiple windows open, that even though I only had one window open, it didn't know what window to go to upon returning from the external file. When working with a database with over 150 files with thousands of scripts, these time consuming patches won't work for me. I'm staying with V6.

I forgot to mention, I am running V7.2.

In V6 I have a Pop-up with values from another file with the "2nd field" displayed and sorted by the 2nd field. During data entry, the user would enter the field, the pop-up would display and the user could enter the first few characters of the 2nd field and the value in the 1st field would be inserted into that field. In V7, when the user enters the 1st few characters of the 2nd field, the pop-up jumps to to a match based on the 1st field, not the 2nd field. An example would be a Product ID (1st field, and Product Name (2nd field). How can I get V7 to find Product ID based on pop-up showing Product Id and Product Name?