Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


gczychi last won the day on October 14 2016

gczychi had the most liked content!

Community Reputation

1 Neutral

About gczychi

  • Rank

Profile Information

  • Title
  • Gender

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Yosemite, Mojave, Win 7, Win 10

Recent Profile Visitors

2,680 profile views
  1. Hi, I'd like to INSERT new records, but only, when they not already exist. Otherwise I‘d need to update existing records. There is a handy command in MySQL and I wonder if there’s a workaround for our SQL92 engine? INSERT INTO table (column_list) VALUES (value_list) ON DUPLICATE KEY UPDATE c1 = v1, c2 = v2, ...; Thanks a lot for your comments! Gary
  2. GREAT, works like a charm! I tried everything, and the only thing that I missed was the second field name ", Konto.Name_short" in the GROUP BY line. I kept getting the error message — and now I know that THIS error message was actually saying where the problem was… 😀 All non-aggregated column references in the SELECT list and HAVING clause must be in the GROUP BY clause. Thanks a lot!
  3. Hi, I have a table Beleg:: that I can query like this SELECT Beleg.id_Konto, COUNT ( Beleg.id_Konto ) FROM Beleg WHERE Beleg.Year = 2020 GROUP BY id_Konto To get the COUNT of each id_Konto in Beleg: 2e974529-5bf6-47e1-b1a7-05b3b2582aea 397 cb54987b-1eec-4868-bcb5-14e2efccc1be 83 ea461038-43f1-43b8-8d68-a2f357f7f41f 27 And I have a table Konto:: that has the names for the id_Konto = Konto.id values: SELECT Konto.Kontonr , Konto.Name_short FROM Konto WHERE Konto.id IN ( SELECT ( Beleg.id_Konto ) FROM Beleg WHERE Beleg.Year = 2020 ) ORDER BY Konto.Kontonr
  4. Thanks, Kaizentu, it’s not really elegant, but nor is FileMaker scripting. For Loops, I'm ususally using the self resetting loop script from fmstandards, which is pretty cool (see picture). But FileMaker shouldn’t consider these instances as errors. So, what could prevent the no records found «error» to appear in the event list? Thanks, Gary
  5. Browsing through my event logs, I am finding weird scripting errors, like: ... Information 645 ...local Schedule "Import Main (every minute 8-20)" scripting error (401) at "Import : Import Main : 36 : Perform Find". How can a simple «Perform Find» script step (which works just fine in the server scheduled script, btw.) generate a scripting error? Occasions where the FoundSet = 0 should be considered «normal». I also have found other errors, that shouldn't be errors, like «Go to Record/Request/Page [ Next ; Exit after last ]», when there is no next Record. What is the best way
  6. That did the trick! After I changed the field to text, everything works now as it should. And the problem inserting «1¶2¶3» was also related to the wrong field type. Thanks a lot!
  7. I have a Number field «Kontakttyp_enum». It contains multiple (!) number values, depending on what the user has deemed to select (see picture). It works great — numbers appearing and disappearing in this field, depending on which checkboxes are clicked upon. Now, I’d like to set this field with the «Set Field» script step — but I can’t figure out how. I can read specific values (for example with the function «Position ( Kontakttyp_enum ; 6 ; 1 ; 1 )», but I don’t know how to add or remove a specific number. Has anybody any insight on this? It’s quite interesting. Even though it
  8. Hi, good idea. However, since the PersistentID is not unique (see: https://community.filemaker.com/thread/85477), it would create a lot of hassle to work with this one. Thanks, Gary
  9. It’s not as easy as: PatternCount ( Get ( ApplicationVersion ) ; "Server" ) Anyone know how I can determine if the FM application (FMP or FMPA, not Server) that a script is running on is the client or the server application? When using a remote database that is hosted on a FM application (not FMS), speed is very often an issue. So I need to determine if a script is executed locally on a FM application that is acting as the server (fast) or if the script is running on a client FM application accessing a remote database (slow). I would need to Exit the Script in the latter case.
  10. OK, I have found the problem: The account that I use in FMS to execute the script was not defined in both files, but only in one. Makes sense. So, in order to be able to access data in an external data source, the same account which FMS uses to execute the script needs to be present in both files.
  11. FMS17: In my Import.fmp12 database, I have specified an external FileMaker database file:Main.fmp12 and added a couple of table occurrences to this file (with the same names as in Main.fmp12) and added the corresponding layouts. When I open Import.fmp12 from a client, I can see and work with all records of the Main.fmp12 file, just fine. From the client, I can also run any script just fine. However, when I run the same script as a scheduled script from the server (only with server compatible script steps, of course) the script runs, but I can’t see any record ! Here are some scr
  12. Hi, we're using Rest API and we are not using FileMaker web hosting. Therefore, a landing page like «FileMaker Database Server Website» doesn’t make sense for us (looks a little bit like the Boston T in blue). Better would be to redirect a user to the company website, which resides on another server and has another subdomain. I’m not sure where we could change that, but it may be something like: Redirect all requests for FileMaker’s landing page, which are not for port 443 OR does NOT contain the string "/fmi/data/v1/databases/DATABASE/sessions" to "www.anotherwebsite.com:80".
  13. SOLUTION Since no one seems to be interested enough, I thought I come up with a solution (more than a hack, but hey, it works ;-) Here again, the categories: Main Category «Vehicle»: «Car», «Agricultural Vehicle», etc. Sub-Category «Car»: «Roadster», «Limousine», «Van», etc. Sub-Category «Agricultural Vehicle»: «Tractor», «Transport Vehicle», etc. Whenever I choose «Car» as vehicle, I want to see in my sub-category value list «Roadster», «Limousine», etc. When «Agricultural Vehicle» is the main category, I want the second value list to show «Tractor», «Trans
  14. I wanted to extend Matt’s proposed use of value lists in his Scriptology Mastery Course to use Conditional Value Lists — but I failed 😞 There’s not much missing, any idea on how to do such a thing? Thanks! )
  15. Hi, being inspired by Matt Petrowsky’s YouTube video (Lesson #2: Scriptology Mastery Course FileMaker; BTW a great video series!) I added a "ValueList" table to my solution and it works just fine. However, I can’t make conditional value lists work. I'm lost! In the example that Matt gives, you set up a ValueList table containing all the category/value pairs of your whole solution and make a self joined relationships to that table for all value lists you would like to see. Keys are text constants that you define that hold the exact category names. Please see below the attached Va
  • Create New...

Important Information

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