Jump to content


  • Posts

  • Joined

  • Last visited

About hociman

  • Birthday 12/03/1978

hociman's Achievements


Contributor (5/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Hello, I am using FileMaker Server 9v3 with Mac OS X Server v10.5.4. I have observed that FileMaker Server will not send email notifications on port 587. I can get it to work with port 25, but port 587 does not work. This does not work despite the fact that when I click "Test SMTP Settings..." in the admin console, I receive a prompt stating "The SMTP test was successful." No, it wasn't! Anyway, if anyone knows how to have FileMaker Server 9v3 send emails via port 587, I would appreciate you pointing me in the right direction. If it can't be done, perhaps someone on the inside can log a bug with FileMaker? Last I checked, they wanted to charge me for support, and if they determined it was a bug, refund my money after the fact. I don't play those games. Thanks for reading!
  2. Hello. I am using FileMaker Server 9.0v3 with Mac OS X v10.5.2. I am attempting to use the Database Upload Assistant within the Admin Console to transfer a database from a computer running FileMaker Server 8 to the 9.0v3 server. I am choosing to upload to the Default Folder, and to NOT open the database after the upload is complete. When I click the Next button to actually upload the database, an error appears that reads as follows. "Could not create the folder: /Volumes/Macintosh HD/Library/FileMaker Server/Data/Databases/" Has anyone seen this before? If so, how does one work around it? Thanks for reading!
  3. Vaughan, Thank you so much! I had tried a loop previously, but was unsuccessful. Cheers!
  4. I am using FileMaker 8.0. I have a database with a value list field whose options are "Yes" or "No". I would like to write a script that will go through all records in the database and change any instances of "Yes" to "No". Is this possible? I tried doing it the following way but was unsuccessful. Show All Records Go to Field [Contact::RSVP] Set Field [Contact::RSVP; Contact::RSVP = "Yes"] Go to Field [Contact::RSVP] Perform Find/Replace [No dialog; Contact::RSVP = "Yes"; Contact::RSVP = "No"; Replace] Thanks for reading!
  5. Could the Clear step in your script be affecting the last record?
  6. In the record that is not being updated, is NewReqDate a later date than Req_Date? If so, perhaps its prior to 1900? If neither applies, I would wonder if the record that is not being updated is actually being found by your calculation.
  7. I have created a database with different layouts for each table, but the header section of each layout is the same. Each button (New, Delete, etc.) uses the New Record function. Since the New Record is only created for the table currently being viewed, I don't have to write a script for each table. I will suggest that you double-check your relationships with such a setup, as you may not want to delete related records from a different table when you delete a record from the current table.
  8. FM 8v2 with Server 8v2 I have a script with a step that reads as follows: Go to Related Record [show only related records; Match found set; From table: "Spots"; Using layout: "spots" {Spots}] After that line in the script, concatenation is done based upon the results of that script step. What I am observing is that if there are no (zero) related records in the Spots table, I am getting a concatenation of ALL the records in the Spots table (which are unrelated to the record I am currently working with). Is it possible to skip the subsequent series of steps if the number of related records is zero, as opposed to proceeding with the script for ALL records in the table? Conceptually, perhaps something like "If the number of related records is zero, do nothing". Any assistance is greatly appreciated. Thanks for reading!
  9. I am using FMP 8v2 in conjunction with Server 8v2. I have a field whose value is a calculation using the Get ( FoundCount ) function. The problem I am having is that if the number of records is reduced, the value in the field using Get ( FoundCount ) is not updated. For example, if Get ( FoundCount ) finds 3 records, the number 3 appears in the field using that function. If I delete a record, I now have two (2) records, but the field using Get ( FoundCount ) will still display 3 for a value. Is Get ( FoundCount ) supposed to update dynamically with the found set? If it is, I think I found a bug. If it is not supposed to update dynamically, is there a way I can force an update without initiating a find again? Thanks for reading!
  10. You are an excellent mind reader then! : Would a PDF of the relationships graph help?
  11. Comment, Thanks! It works your way, but can you explain why it did not work my way? I would like to understand why it did not work, as a means of building up my FMP knowledge.
  12. To the 20+ people who read my post, thanks for reading. I managed to solve the problem quoted above by changing how my tables were related to one another. However, I still have a problem with value lists. Perhaps this other problem is easier to solve. When I click in the LocID field, I now see a value list of all of the LocIDs affiliated with a CompID. However, when I choose a LocID other than the first one displayed, the LocID field seems to ignore my input and it continues to display the first LocID in the list. Now, here's where the problem gets interesting. If I type the second LocID value displayed in the LocID field's value list into the LocID field with the keyboard, then the related fields show the data with the LocID that I typed in (which happens to be the LocID that FMP is refusing to let me choose from the value list). I suppose the question now is why would FMP refuse to acknowledge my choice in the value list, and what can be done to make it accept my choice and display the related data in the fields? Thanks for reading (again, if you are revisiting).
  13. Are you using a custom value list, or is its contents based on the names or contents of other fields?
  • Create New...

Important Information

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