Priyabrata

Hi Guys, I installed the Zulu version 2.06 in Mac OSx El Capitan. The installation process does go through, but at the end it showed a dialogue of the Zulu is installed but the web server forwarding is not working and asked to redirect to a URL. And on clicking "ok". It directed to the page shown in the below screen shot. Please advise. If there is anything i am doing wrong.

Its happening with one of the Client. He shared it's happens in random. Most of it happens during the certain time block during the day. I checked the crash logs, most of the crash did happen between 4-6 PM. Could this be some issue related to system performance issue or system slowdown ?

The FMP 15 crashes randomly after every 2-3 days on windows systems. I have checked the issue for the fault module in event log (Fault Module Name: mshtml.dll) and some place i checked it was suggested to reinstall the application, which i have tried multiple times. But the crash still occurs. Is there any possible solutions to avoid it ? Does it have anything to with the application running a hosted filemaker files or is it a system issue ? Thanks for help in advance. Event Log Below for the crash: Description Faulting Application Path: C:\Program Files\FileMaker\FileMaker Pro 15\FileMaker Pro.exe Problem signature Problem Event Name: APPCRASH Application Name: FileMaker Pro.exe Application Version: 15.0.1.119 Application Timestamp: 5706f6ea Fault Module Name: mshtml.dll Fault Module Version: 11.0.9600.18450 Fault Module Timestamp: 57c77567 Exception Code: c0000602 Exception Offset: 0000000000aad57f OS Version: 6.1.7601.2.1.0.256.48 Locale ID: 1033 Additional Information 1: bd38 Additional Information 2: bd38c20a435ecf91f7600d0cd116acda Additional Information 3: ce62 Additional Information 4: ce6256c209e56407251e741df07c99ae

Yes Its because the Filemaker 64 bit Windows doesn't work with outlook for sending emails via email client. Could this be the reason behind the crashes ? Please advise.

Hi Guys, I am having some issues related to FM Pro crashing. One of the client who is on windows 8.1 the FM Pro 14v5 crashes unexpectedly almost everyday. They access the Filemaker files that are hosted in a Filemaker 14v4 Server hosted in Windows 2008 R2 system. This issue is happening on the windows system only. The client has 2 windows workstation and one workstation using a iMac. The Filemaker crash is happening only on the windows system. The iMac has never crashed. We tried increasing the RAM in server and the windows workstation systems, but it didn't help. On checking the windows event log found this: Faulting application name: FileMaker Pro.exe, version: 14.0.5.505, time stamp: 0x56a2e6d5 Faulting module name: KERNELBASE.dll, version: 6.3.9600.18264, time stamp: 0x56e1b34d Exception code: 0xc06d007e Fault offset: 0x00015b68 Faulting process id: 0x2bb8 Faulting application start time: 0x01d1a6dffb4b4c7a Faulting application path: C:\Program Files (x86)\FileMaker\FileMaker Pro 14\FileMaker Pro.exe Faulting module path: C:\WINDOWS\SYSTEM32\KERNELBASE.dll Report Id: 8754507d-12ff-11e6-bebd-485ab683c708 Faulting package full name: Faulting package-relative application ID: Is this something related to the issue in the application hosted ? Or is it a issue in the windows workstation system ? Any advise or suggestion will be a great help. smile emoticon Thanks in advance. Note: Already tried reinstalling the FMPro in the windows system

I hope some one must have come through this and have solved this type of issue. We are trying to provide public access to FM files in web direct using an external IP. But the External IP doesn't seem to work. While Checking the ports mappings of the system, and came through that the port 80 is been blocked by default web service. So is there any way to map the correct ports to filemaker so that we could be able to access the web direct files using an External IP without affecting the other web services using those ports ? Any suggestions....

Thanks for the feedback. It helps.

  Hi,   Need some suggestions and help regarding the Filemaker 11 files hosted in the FM11 server being get disconnected or communications with the host gets interrupted.   Though it is obvious that the cause is network gets disconnected or inconsistent internet connection lead to these type of issues.   But are there any more possible reasons that also lead to host interruption issue followed by host being disconnected.   Attached screen shot.    Any help or suggestions would be appreciated.Â

Hi, For this search method, to search for specific subset sample across multiple tables, can use the Execute SQL statement. Here we can use the %LIKE% operator to get the values from the fields for the Subset of the samples. We can get the values from different tables for different samples using the separate Execute SQL statements and concatenate all the values into a single list of value.

Thanks for Clarifying. Will keep that in mind.

Yup, you need to have the file reference in the External Data sources referring to the server file using the hosted server IP path. Do you open all the files hosted in the server using open file script step in the "OPEN FILE" or the Launcher file what we can also call.?

Oh, there is one for this. I haven't come up with that. But I still think there are some differences between the parameter passing and there are some variations in output. Like if user passes incorrect dates as parameter to the function then it returns "N". In the custom function i have created, there no need to format the date parameters through the Date functions, instead it can directly pass the date parameters as text with quotes. Although the WeekdaysinRange seems to be more preferable as it gives the dates for multiple week days passed in the parameters. So i will try more to get the function better.

I have been working on FM 12 solution. Whenever I try to perform find for an particular Order record, 2 records are found in the found set. Where one record in the found set is the original record been searched for and another record is an blank record where all the fields in the record contains "?". So thinking it as a corrupted record i deleted it. It changed the found count to 1. But deleting the record didn't affect the total record count. It is same as the before And after doing that, I again made the performed a find for the same order no. again 2 records in the found set appears with one of them is an undefined record (Ghost record) that been deleted previously. And the issue is also only produced when find is performed for an particular order record only. Thinking of the file been corrupted, recovered the file but the issue still persists Confused and Surprised. Please advise, if there is any solution to it or any certain cause that leads to this.

A function to finds all the dates for a week day within an given date range. For example: We need to find what are the dates for the Thursdays in the date range starting from 1/1/2013 to 1/31/2013. In this case: The function would be defined as FindDay ("1/1/2014";"1/31/2014";5) Here the start date and end date in the function parameters are text. Here the 5 refers to the number that represents Thursday in the week. Output: 1/2/2014 1/9/2014 1/16/2014 1/23/2014 1/30/2014 And for the invalid dates passed as the function parameters would return "N" that refers to NULL. For Reference: Sunday: 1 Monday: 2 Tuesday: 3 Wednesday: 4 Thursday: 5 Friday: 6 Saturday: 7 FindDay Function Parameters : Parameters Type StartDate : Text EndDate : Text DayN : Number Function Body : Substitute ( If(GetAsDate(GetAsText(StartDate)) ≤ GetAsDate(GetAsText(EndDate)); Let( [ start = GetAsDate(GetAsText(StartDate)); end = GetAsDate(GetAsText(EndDate)); Day = DayN; Day1 = DayOfWeek(start); Diff = Day - Day1; FinalDay = If(Diff < 0;start - Abs(Diff) + 7;Start + Diff) ];If(FinalDay > end;"N"; FinalDay & ¶ & FindDay (start+7;end;Day)) ); Let( [ start = GetAsDate(GetAsText(StartDate)); end = GetAsDate(GetAsText(EndDate)); Day = DayN; Day1 = DayOfWeek(start); Diff = Day - Day1; FinalDay = "N" ];FinalDay ) );¶ & "N";"")

In Comparison to the Filemaker value count function in compared to the Count, it is slightly slow. In case of using the ExecuteSQL Sum() function, it is really slow in compared to that using any custom function to sum down the values in a list.

It would be more faster and efficient to use the Filemaker value count function instead of using the Exceute SQL count () funtion. ValueCount( ExecuteSQL(....) )

Yes, the most best way of using the ExecuteSQL statements query to be handled using the Variables using the let function. I prefer it most. Instead of using the Execute SQL sum function, its better to get the value list extracted from execute SQL statement and using a custom function to total up the values in the list. As the SQL SUM function would make the the application process slow if we have a large amount of records.

Hi David, You are correct mate, I only clarified that the ExecuteSQL() works as they wanted. The list also works the same and i didn't deny it. So i think we both are right. Thanks

Hey Eos, Thanks mate ,for correcting the execute SQL statement posted by me. I had missed the spaces in the field name.

Hi, Now try this query, it would work and ignore the case sensitivity of the fields. ExecuteSQL ( "SELECT "Address ID" FROM "Addresses!Contact ID" Where "Contact ID" = ? ORDER BY " & Lower($field) & Case ( $$sort_desc; " DESC" ) ; "" ; "" ;Suppliers::Supplier) Regards Priyabrata Sahoo (Priya) Mindfire Solutions India

Hi, Now try executing this SQL command: ExecuteSQL ( "SELECT Administrative Password FROM Preference WHERE Search Text = ?" ; "" ; "";Preference::Administrative Password) Regards Priyabrata Sahoo (Priya) Mindfire Solutions, India.

Hi, For you question regarding the SQL result in filemaker. Your assumption is correct. The ExecuteSQL function would only return the list of values for the fields requested in its query. Regards Priyabrata Sahoo Mindfire Solutions, India

Hi All, Today I also faced a bug while trying to create an execute SQL calculation for a field which needs to compare the time stamps. While we make a comparison of an time stamp data in an execute SQl statement with the Filemaker time stamp fields. The comparison wasn't made based on time stamp rather it was comparing only the time part from the time stamp and wouldn't consider the dates in the time stamp for comparison. For Example: if we want to compare an time stamp value in an Execute SQl statement that is 2013-09-04 12:00:00 > 2013-09-03 21:00:00 It compares the time from the time stamps and returns 0. 2013-09-04 12:00:00 < 2013-09-03 21:00:00 And for the above the condition it returns 1. I tried to make the above comparison by converting the time stamp in filemaker to the same format that results out from an SQL query. Thanks Priyabrata Sahoo Filemaker Developer Mindifire Solutions www.mindfiresolutions.com

Sorry My mistake... Apologize for that...

Hi bruce The Go to Record/Request/Page[First] is outside the loop and there is no Go To Record next script step in my post.