Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.filemaker > #2420
| From | SciFi_Reader <SciFi_Reader@nowhere.com> |
|---|---|
| Newsgroups | comp.databases.filemaker |
| Message-ID | <2015100216531280685-SciFiReader@nowherecom> (permalink) |
| References | <2015100108515775158-SciFiReader@Bellsouthnet> <021020151317014456%HelpfulHarry@BusyWorking.com> <2015100209245185209-SciFiReader@nowherecom> <mumbsh$iqs$2@news.motzarella.org> |
| Subject | Re: FMS 11 Scripting |
| Organization | Public Usenet Newsgroup Access |
| Date | 2015-10-02 16:53 -0500 |
On 2015-10-02 16:39:41 +0000, Howard Schlossberg said: > On 10/2/2015 7:24 AM, SciFi_Reader wrote: >> here is the actuall code of the varible and the script below: >> >> NeedsToBeOrderedFlag: Calculation unstored >> If((Customer Open Orders + Qty On Back Order) > (Qty On Hand + >> Vendor Open Orders + Received Today);1;"") >> >> >> Enter Browse Mode [] >> Show All Records >> >> Go To Layout ["Qty's to Order"] >> Enter Find Mode [] >> Set Field [NeedsToBeOrderedFlag; 1] >> Perform Find [] ----here is were it borks on the server but not >> on client > > Can this calc field be stored/indexed, or are one or more of its > components necessarily unstored? That might help with the server-side > finds. I've seen situations where some finds unexpectedly don't work > on server and I have seen this as a factor. > > Howard Howard; unfortunately the calc field CANNOT be stored / indexed; I kinda figured (after some trial and error) that the storing / indexing might be a problem in the find. But I tried to loop though the records and set a regular field to the calc field, and that action bowmbed too. Can you not use a calc field at all in a server side script?
Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
FMS 11 Scripting SciFi_Reader <SciFi_Reader@Bellsouth.net> - 2015-10-01 08:51 -0500
Re: FMS 11 Scripting Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-10-02 13:17 +1200
Re: FMS 11 Scripting SciFi_Reader <SciFi_Reader@nowhere.com> - 2015-10-02 09:24 -0500
Re: FMS 11 Scripting Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2015-10-02 09:39 -0700
Re: FMS 11 Scripting SciFi_Reader <SciFi_Reader@nowhere.com> - 2015-10-02 16:53 -0500
Re: FMS 11 Scripting Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2015-10-02 20:30 -0700
csiph-web