pnmgman

I am hosting a database on 8.0 advanced server and whenever I use the GROUP BY clause from FMP 8 on a client PC, the server goes to 100% utilization and takes nearly a half hour to return results. Can someone tell me if this behavior is normal for FMP when using GROUP BY. I know it's the GROUP BY clause because when I remove it, the code runs fine (still slow but tolerable). I need to know how to optimize this code so that it executes within seconds or if I am SOL. Any help would be appreciated - thanks! The sql is as follows: SELECT "Asset Inventory"."ProductID", "Asset Inventory"."OrderDate","Asset Inventory"."ProductType","Asset Inventory"."MfgrID" FROM "Asset Inventory" WHERE LOWER("Asset Inventory"."ProductType") = 'software' or LOWER("Asset Inventory"."ProductType")='swflicense' or LOWER("Asset Inventory"."ProductType") = 'swflicense-server' GROUP BY "Asset Inventory"."ProductID", "Asset Inventory"."OrderDate"

It is very promising, but extremely buggy on IE when doing more than just simple pages. Open URL comes to mind, completly useless and I still have not found a work around. (appends HTTP to everything except mailto!), also, for some unknown reason, fields become unenterable.

Let's see what I can offer to sort this out: first, you did not specify if this was a Web Application or Client/Server, or both, so here is the poop on Send Event and Open URL: First, Send Event is not Web Compatable; however, Open URL is, obviously. But, Open URL does not open anything other than web pages and email when used from IWP (Don't know about Custom), and for reasons no one seems to have a definitive answer for even though the documentation says that it will. You will notice that anything you try with OpenURL in IWP, other than mailto will append an http:// to the address. However, in a ClientServer, Open URL works just fine, and so does send event. For the platform dependant part of you question, let me try this: Filemaker works on both Mac and Windows, so send event will work accordingly depending on what OS the solution is installed under. You may need to have a Windows and Mac version of your solution (I am not 100% sure about this), but it makes sense since the file-level command syntax and calls are very different. So the short answer is that your solution may be platform dependant, however, Filemaker as a development environment is not. Lastly, two-way data communication might be better accomplished using an ODBC connection to your original tables. I don't know enough about PERL to even begin an answer here. I am not en expert by any means, and am largely full of crap usually, but hope this is of some help. If for no other reason than to start some dialog with real experts! Good Luck!

Let's see what I can offer to sort this out: first, you did not specify if this was a Web Application or Client/Server, or both, so here is the poop on Send Event and Open URL: First, Send Event is not Web Compatable; however, Open URL is, obviously. But, Open URL does not open anything other than web pages and email when used from IWP (Don't know about Custom), and for reasons no one seems to have a definitive answer for even though the documentation says that it will. You will notice that anything you try with OpenURL in IWP, other than mailto will append an http:// to the address. However, in a ClientServer, Open URL works just fine, and so does send event. For the platform dependant part of you question, let me try this: Filemaker works on both Mac and Windows, so send event will work accordingly depending on what OS the solution is installed under. You may need to have a Windows and Mac version of your solution (I am not 100% sure about this), but it makes sense since the file-level command syntax and calls are very different. So the short answer is that your solution may be platform dependant, however, Filemaker as a development environment is not. Lastly, two-way data communication might be better accomplished using an ODBC connection to your original tables. I don't know enough about PERL to even begin an answer here. I am not en expert by any means, and am largely full of crap usually, but hope this is of some help. If for no other reason than to start some dialog with real experts! Good Luck!

Let's see what I can offer to sort this out: first, you did not specify if this was a Web Application or Client/Server, or both, so here is the poop on Send Event and Open URL: First, Send Event is not Web Compatable; however, Open URL is, obviously. But, Open URL does not open anything other than web pages and email when used from IWP (Don't know about Custom), and for reasons no one seems to have a definitive answer for even though the documentation says that it will. You will notice that anything you try with OpenURL in IWP, other than mailto will append an http:// to the address. However, in a ClientServer, Open URL works just fine, and so does send event. For the platform dependant part of you question, let me try this: Filemaker works on both Mac and Windows, so send event will work accordingly depending on what OS the solution is installed under. You may need to have a Windows and Mac version of your solution (I am not 100% sure about this), but it makes sense since the file-level command syntax and calls are very different. So the short answer is that your solution may be platform dependant, however, Filemaker as a development environment is not. Lastly, two-way data communication might be better accomplished using an ODBC connection to your original tables. I don't know enough about PERL to even begin an answer here. I am not en expert by any means, and am largely full of crap usually, but hope this is of some help. If for no other reason than to start some dialog with real experts! Good Luck!

I have an application that stores UNC paths to executables in a table. I use the open URL script step so that when a user click a button it executes the program at that path. In the client application, the button works fine; however in IWP, the URL is concatenated with HTTP: so that the resulting URL is HTTP://FILE://xxxxxx/xxx/xxx/xxxx.exe. I cannot seem to find the work around for this. If I manually remove the http: from the address bar and hit go, the link works as expected and the program executes. Does anyone have any ideas? Thanks in advance!

When I attempt to connect to a Filemaker server host from FMS Admin Tool, I get "login failed" What login and how do I change it? There does not seem to be any functions available in the tool at this point other than to Connect. I am running Win 2K Server and have FMSA Updater 2 installed. This is a really frustrating problem.