Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About GeoSteven

  • Rank
  • Birthday 05/05/1952

Profile Information

  • Gender
  • Location
    Upstate SC

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Catalina, Win10 Pro

Recent Profile Visitors

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

  1. bcooney - thank you for the advice. When I imported the zipcode file the fields that were globals in the old table did not import as globals but rather as text fields. <facepalm> . Wish I'd seen your response sooner but in the end I wound up re-writing the script so that passing parameters became mute. As mentioned this was old code from FM6 and I was trying to make a quick change. We all know what a quick change can turn into. Wim Decorte - setting a global field in another table from anywhere can be done as long as the tables are in the same file but unless I'm mistaken this doe
  2. All files/tables in this discussion are fmp12 using FM 17 and both files are opened when initiating the app. "logging" is opened as the primary file and "claims" is opened as an external data source. I have a table called "newclaim" in "logging" which contains mailing address information including a USPS zip code. I have a table called "lu_ZipCode" in "claims". There is a relationship set between "newclaim" and "zipcode" on a field called "COID" (company ID). This field is automatically populated in both tables with "DCSI". This is an old method (used in Fm6) of establishing a simple rela
  3. Sorry for my delayed response. ggt, I am updating the record using a 'set field' command. I was able to capture the error as needed by using Wim's suggestion of placing an 'open record' step before the "set field" step. However, the underlying problem, which I found while gathering info to give you both feedback, was that I am looping through a found set of records. When a certain condition is met I call a subscript to add/replace a record in a related table. In that subscript I was also updating the field in the parent table (from the related one) then, upon returning to the calling scri
  4. I am running a server side script that attempts to update records in a MySQL table that is set up as an external data source. It runs without issue for hours to weeks at a time then gets hung on error 512 (Record was already modified by another user). The problem is that I can't figure out how to capture and handle this error. I've tried adding "If get(lasterror)=512 then <skip this record and continue to next> just after the 'Go to Record(next)' but it never gets to that step. Instead hangs on try to move the record pointer and writing error after error to the log. I've searched t
  5. Thank you Lee for getting me to the right place. And thank you Wim for the solution. Works like a charm when you know what to do!! :<)
  6. This is hurting my head trying to remember this far back. I'm trying to put together a test platform for an FM6 application. The current production platform pulls data from a MySQL database (that resides on the same physical server with FM6). The client wants to have the MySQL hosted offsite so I need to test pulling the data while MySQL is installed in a different city/state. It should work but while trying to define the host in the "Import Records" script step I can't get the host to present the tables. I have placed a copy of the entire FM6 project on a separate laptop with FM6ProDev in
  7. just to follow up on this - 360 works educated me on this. I was using the interal IP address (ex in the web viewer URL instead of the external one (ex www.mydomain.com/subaddress). Naturally this failed because any user outside our LAN would be directed to their own local IP address. A real 'duh' moment for me.
  8. Good morning - I'm also developing a runtime that I need to provide similar protection. I'd be interested in learning more about how you intend to accomplish this or if you have found any authoritative references on the subject. - thanks
  9. I know this thread is kinda old but it's the only one I can find that relates to the issue I'm having. I believe my issue has been caused by the same thing but cannot figure out how to do the forensics. Based on the previous post it would seem that a field in my DB is requiring validation that has not been met. When the user canceled out of the dialog the server started throwing these errors (see attached log file). How can I tell which field is the culprit? How can I recover from this in my current DB? What can I do to prevent this in the future? FM11dev_serverlog.txt
  10. We have FMSA 11 on (server name FM01) which is serving our "VM" app via IWP. We have SC installed as a stand alone on a different server (SC01) which has been modifed to place documents on a 3rd server (FS01). We will not be using the SC plugin so we've designed a portal with a web viewer next to it to show the document related to the record chosen. Everything works as expected using an FM11 client or IWP… as long as we are within the firewall (on the LAN). If I try to access the docs (via IWP) from any point outside our office the browser brings back all of the related record information
  11. sd - I agree Randy that more explanation would be useful. There seem to be a lot of nebulous replies in forums that the inexperienced undoubtedly struggle with. My attempt to offer a complete explanation was not a defacto schema design but hopefully offered enough information to provoke a constructive train of thought. I would also agree with you that the 3 tables have a lot of common attributes which could/should be placed in a 'contacts' table which would be tied to the 3 tables mentioned. I will point out though that the 3 roles I described are different enough that they should be sepa
  12. OK - I think I understand. I would design this with 3 separate tables, one for each role. Company (me), Clients (pay me for my services) and Vendors (I pay them for their services). Company becomes the 'prefs' or control table and is related to vendors and clients via CompanyID. Now the only question left would be is this a distributed application or a web hosted one? If it's distributed and only a single company will have access to it (ie - instaled on their servers on their premises) then when the package is initially installed you direct the user setting it up to enter the perti
  13. Hi Randy, It may help to describe to us what the company is. You mention clients and vendors. What role does each play in your business model? Do your users work for different companies and you want the company to be set depending on what user logs in? Steve
  14. I know I'm jumping in late here but I ran across this thread looking for something else. My answer to your issue seems simpler to me. Create (or open) any other database. Set script debugger on. Open 'locked' database. Go to scriptmaker from the debug window. Remove offending script step. Save... :
  15. I am currently facing this same issue. As old as it is there must be a solution but I cannot seem to find it. I've been to several forums where the question is asked but no answers are given. Is there a way around this annoyance? FM10 advanced WinXP Pro Outlook 2003
  • Create New...

Important Information

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