Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


LaRetta last won the day on October 14

LaRetta had the most liked content!

Community Reputation

496 Excellent


About LaRetta

  • Rank
    Lifelong FM Student

Profile Information

  • Title
  • Industry
  • Gender
    Not Telling
  • Location

FileMaker Experience

  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. LaRetta

    Record navigation

    Hi Gismo, I also noticed that you are using '/' in your table and field naming. Filemaker will always warn you that it cannot be easily used and you should take those warnings seriously. I highly encourage you to correct your table and field naming.
  2. LaRetta

    File could not be created on this disk

    Hi Jim, I had not received an email of your response! Again, the error is probably in the path name. Please paste the exact result string of $SavePath here. Get ( FileName ) might be your problem but we need to see the resulting string.
  3. LaRetta

    How are these Orphans created

    I hear ya. I was sure hoping we could help you identify it as well and maybe someone else here can. Funny person!!
  4. LaRetta

    How are these Orphans created

    Then why is Allow Creation turned on for the Quotations side? Nonetheless, I don't believe that addresses your issue. Tables which must stay in balance, such as Invoice/LineItems or Quotations/QuoteItems should be handled transactionally and when created/edited on FMGo online or offline, it is critical good logging and error trapping be in place. Please see: Transactions. I doubt this is something which can be resolved from a forum post, unfortunately. Maybe your sync is failing in uploading new Quotations but uploads their QuoteItems.
  5. LaRetta

    How are these Orphans created

    Sorry, this is a bit deceiving because I didn't finish my thought. We don't know your record-creation or duplication scripts or your auto-enter calculations nor have we seen your graph so we don't know where the breakdown happens but if an ID is improperly set or modified other than through that 'Allow Creation' relationship then the QuoteItems 'parent' could disappear (although the record would not actually be deleted). I again suggest you take a look at those duplicate 'copy' keys and also verify that you have the proper key fields on the layout if you have multiple table occurrences of those tables and be sure keys are set to 'prohibit modification of value' and set to 'unique'. If you create an empty clone of your file and post it, we might be able to spot the issue.
  6. LaRetta

    How are these Orphans created

    How then are orphans created? You have IDs with 'copy' after them. Why? Is it possible that the parent records aren't deleted but rather their ID has been changed so they are no longer related? Do you prohibit modification of the primary key ( in field definition)? I also recommend adding detailed error trapping and logging, such as: Dan Smith's Logger. Robust logging can help you identify issues. Maybe until you identify the issue, don't delete but rather flag records for deletion and clean them up later. It is also possible that the __Quoteid Copy of Quotations is incorrectly holding the parent ID if the parent has been created from within QuoteItems ( since you have Allow Creation on the parent Quotations side). The __QuotidMine is also suspect. We do not have enough information to identify the issue. I suggest you hire a competent Developer to review your solution. And no, this isn't a plug since I'm not currently available. 🙂
  7. LaRetta

    How are these Orphans created

    Hello to South Africa!! Three ways come to mind that it might happen (but there might be more): 1. You have indicated 'Delete related records in this table when a record is deleted in the other table' on the wrong side of a relationship. 2. You have a Go To Related[] step which fails to switch layouts or accidently isolates the parent Quote records of a record-set of QuoteItems and your script has then issued Delete All Records step on the Quote table. 3. Your User is in a portal and button issues a 'Delete Record' instead of a 'Delete Portal Row.' The easiest thing to check is the relationship. It's easy to accidentally specify the wrong side. It helps if you mark all your relationships by using text to add a plus or minus next to the occurrence where those options are specified. I also like to include an 's' to indicate there is a sort. In this way, it will be easier to spot the culprit. As for #2 and #3, that would require a bit of detective work. If you use GTRR[] and it is not *properly error trapped, it can fail and if one of your scripts then issues a 'Delete Records', you again can be on parent record set. I hope it's #1 since you can then fix the issue quickly and still enjoy your weekend. * properly error trapped ... if you test for Get ( LastError ) or 101 (record is missing) but you issue a 'match found set', it can fail and not switch layouts. You must instead trap with 401 to catch it.
  8. LaRetta

    File could not be created on this disk

    Hi Jim, Are you sure that the other laptop has the folder name FMPstoredfiles exact? Can you make sure there is not a space after the text? Because if you do, you will get that message (in versions prior to 17) because, as Comment points out, the path is invalid (including the folder name). Also check the script which creates the folder name (if you have one). If your script creates a folder name improperly then scripts writing to it properly would fail as well. With version 17, we now have an option in Export Records[] which allows us to create the directory if it doesn't exist. As last resort, it would be helpful if you provided the exact script (or at least screen captured the section on the export). We'll help you figure it out; hang in there. 😃 Updated: There is no difference between FMPro and FMPro Advanced when it comes to that and in fact, version 17 simply includes a checkbox in FileMaker > Preferences > General tab so the Developer can specify whether to allow the User to have advanced tools.
  9. LaRetta

    Timestamp Conversion

    By the way, just because I would use the second calculation for this specific situation, I would use Michael's first calculation for many other situations. We can't have too many tools in our toolkits.
  10. LaRetta

    Timestamp Conversion

    Great Monty Python, Tom! As for code, how will SerialIncrement() become the norm if we don't suggest it and use it? Dumbing down code so it can be read by even beginner Developers doesn't seem appropriate; rather, I think we should educate beginner Developers and nudge them to step up their game, just as Comment did for me ... just my opinion of course. I know that, even when new to FileMaker, I didn't seek out those who taught inefficient and clumsy code but rather those that taught elegant and efficient calculations. While true that clarity is more important than brevity, we all need to learn various methods. For myself, I would probably prefer Comment's second calculation.
  11. LaRetta

    Timestamp Conversion

    True, although few Developers even today take advantage of SerialIncrement() in this way. I surely miss being nudged by you. 😀
  12. LaRetta

    Timestamp Conversion

    Hey Comment! What an elegant way of producing result instead of the old-fashioned and clumsy way of: Let ( ts = TimeStampField ; Right ( "00" & Month ( ts ) ; 2 ) & Right ( "00" & Day ( ts ) ; 2 ) & Right ( "0000" & Year ( ts ) ; 4 ) & Right ( "00" & Hour ( ts ) ; 2 ) & Right ( "00" & Minute ( ts ) ; 2 ) ) Nicely done!
  13. LaRetta


    Hi David! My dog and I both fast for 48 hours every two weeks. The days vary because, as you've said, it depends upon scheduling and plans but I can always fit it in. I've tried going longer but I get grouchy. 🙄 I'd like to because on the second day, my senses are more keen and I've heard that the awareness increases even more but I don't (as yet) have the willpower to pull it off for longer than two days. It's easy to expect my dog to go longer than two days but I wouldn't put her through something that I myself won't do. Remember to (always) drink lots of water.
  14. LaRetta

    Number of Records Added or Deleted

    Hi John, I am unsure of your batch process script so you'll have to adjust this to fit your needs. If [ batch test which decides a new record should be created ... ] New Record/Request Set Variable [ $count = $count + 1 ] End If ... then display $count in your Custom Dialog. We certainly understand that, John! 😃 But as Barbara points out, it is difficult to provide a safe answer when we can't see your script. In truth, depending upon your script, I would put this within a single loop but I couldn't suggest it because I don't know your batch script. Another possibility is to begin on an empty record set ( for adding records ) and then your found count after you've added your multiple new records is the correct answer. You can do this easily by: Go To Record/Request/Page [ First ] Omit Multiple [ dialog: off, Specify: Get ( FoundCount ) ] Then begin adding your records. And if you need to preserve your prior found set, do this in a new window and then just close it.
  15. LaRetta

    Shortcut to move through layouts?

    Hi Lee! I love the 'banana man' ... here is a link to the 'Product Enhancement' request: https://community.filemaker.com/ideas/3192

Important Information

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