AndrewBruno Posted December 3, 2001 Share Posted December 3, 2001 I have an ORDER/INVOICE parent file which has an ORDER LINE child file. In each ORDER LINE record, a specification is made using join fields from a FRAME file and a FABRIC file ( my company makes sofa beds), and also includes quantity and price fields. When the specification of each ORDER LINE is confirmed ( or later amended ), the script(s) include a subscript which updates an audit field in the ORDER/INVOICE file. (This field logs all entries and changes made to that ORDER/INVOICE's ORDER LINES) It's a 1 line script in the ORDER LINE file: Set field (Order|Invoice rder_audit, Order|invoice rder_audit & c_order_line_summary) c_order_line_summary is a concatenated text field using a combination of CurrentStatus fields and fields from the ORDER LINE and FRAME and FABRIC files. The whole element of the program works exactly as I want it to, but the problem is that it doesn't always !. There seems no pattern to it. All the fields include data to produce the calculated field, so there's no difference there. I get no error message and the rest of the script works just fine.It fails around 20% of the time. We run FM 5.5 on 2 new PCs. Any help greatly appreciated. Andrew Bruno [ December 06, 2001: Message edited by: LiveOak ] Link to comment Share on other sites More sharing options...
Vaughan Posted December 4, 2001 Share Posted December 4, 2001 Sometimes when Set Field [] doesn't work for me I use the Insert Calculated Result[] step instead. Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted December 4, 2001 Share Posted December 4, 2001 Insert Calculated Result is best used in date and time fields, especially in FInds. Set field works best with text, numbers, and containers. HTH Old Advance Man Link to comment Share on other sites More sharing options...
dshafer Posted December 7, 2001 Share Posted December 7, 2001 But there seems to be a number of people on this board who believe based on experience that the Set Field script step does not work reliably. Or are they all missing something (because I am, too)? Link to comment Share on other sites More sharing options...
LiveOak Posted December 7, 2001 Share Posted December 7, 2001 I know of no cases where the Set Field() script step is less than reliable. I'm betting that the results reported are due to something else. -bd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8175 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now