wlewnka

After setting up my separation model (interface, business, data) I now get an error message when trying to delete data file records (directly from a data file layout): ("This operation cannot be performed because one or more of the relationships between these tables are invalid.") I have checked all relationships for proper delete rights - to no avail. My interface file has 0 records, just layouts, scripts etc., my business file has calcs and globals. Doubtless I am overlooking something simple, but any thoughts? Thanks in advance!

After setting up my separation model (interface, business, data) I now get an error message when trying to delete data file records (directly from a data file layout): ("This operation cannot be performed because one or more of the relationships between these tables are invalid.") I have checked all relationships for proper delete rights - to no avail. My interface file has 0 records, just layouts, scripts etc., my business file has calcs and globals. Doubtless I am overlooking something simple, but any thoughts? Thanks in advance!

After setting up my separation model (interface, business, data) I now get an error message when trying to delete data file records (directly from a data file layout): ("This operation cannot be performed because one or more of the relationships between these tables are invalid.") I have checked all relationships for proper delete rights - to no avail. My interface file has 0 records, just layouts, scripts etc., my business file has calcs and globals. Doubtless I am overlooking something simple, but any thoughts? Thanks in advance!

This is for a db that is used to record individual daily receipts, called receiptsdb. I have a detail/sub-summary report created in FM5-6 which required the following: 1. A Find of all receiptsdb records in a selected fiscal year (prior to) the currently-selected month; 2. A Sort of this found set, then an Export (FM) of the receiptsdb amount data summarized in 3 ways-to a file called priormonthtemp1; 3. Then an Import of this exported/summarized data into another existing (temporary use) FM file-called priormonthtemp2. 3. Then a new Find in receiptsdb for only the records in the currently-selected month and fiscal year; 4. A Sort of this new found set, then a display of the detailed records for the currently-selected month, along with a sub-summary display of the summarized amounts from priormonthtemp2. So...for each category of receipts in receiptsdb, the report displays the sorted detail records for the currently-selected month, then a total of that same category for all months in the fiscal year prior to this month, then a grand total of receipts year to date. I am testing whether the new features in FM7 (multiple found sets, table occurences, etc.) would allow me to produce this same report WITHOUT going through this complicated Export/Import/display scenario, with no luck so far. Any suggestions would be greatly appreciated. Thanks!

In a multi-user solution hosted by FM Server 5.5, a scripted FM export file (with summary totals) is created and written over each time the script is run. The problem is, each user who runs the report apparently needs their own specific export directory path in order for the script to work correctly on each PC. Keeping this going has required frequent trips to scriptmaker to "reestablish" the proper export directory path. Any suggestions (other than to upgrade to v7, which we will do sometime soon, I hope)? Thanks!

I have solved my script problem. After my test for error code 401, I was using a loop to allow the user unlimited tries to either achieve a successful Find or opt out. My loop included a an exit loop step if StatusCurrentMessageChoice = 2, and I overlooked the fact that the user made a MessageChoice of 2 earlier in the script in order to get to that point - so my loop never fully executed. Thanks to those who took the time to read my posts and try to help. This forum is a great resource!

Curiously enough, the Enter Browse Mode script step does not destroy a previous Find. In fact, I can execute the entire script with a resulting Found Set of zero records, then manually do a Modify Last Find, and be presented with the generic "No Records Match this Request" dialogue. For some reason, my scripted Modify Last Find step, which can also result in zero records found, is not resulting in an error code of 401 in those instances. Thanks for your thoughts, though. For the first time in a long time, I am stumped...

If the original condition is not met (i.e. (summary field count of records) DOES NOT EQUAL Status(CurrentRecordCount), then a previous Find command has been issued. The Modify Last Find step is intended to work with that previous Find, whatever it was. Hope I'm explaining myself properly... THANKS!

Tried that to no avail. Thanks anyway.

I am having a brain cramp. I have replaced the generic Find Mode with a scripted Find routine, shown below. All steps functions properly EXCEPT those shown in Red. When that condition occurs, the script somehow bypasses the Status(CurrentError) check and the result is a Found Set of Zero records. I have also tested for the occurence of the "401" error code, and it is there. Any ideas? Thanks in advance to one and all. Set Error Capture On Allow User Abort Off Enter Browse Mode If(summary field count of records = Status(CurrentRecordCount) Set Field (g_user instructions) Enter Find Mode Go To Field (desired starting field) Pause/Resume Script Else *************problem appears to start here**************************** Show Message (Buttons: 1New, 2Refine, 3"", Data: desired message) If(Status(CurrentMessageChoice) = 2) Set Field (g_user instructions) Modify Last Find Go To Field (desired starting field) Pause/Resume Script *************problem appears to end here**************************** Else Set Field (g_user instructions) Enter Find Mode Go To Field (desired starting field) Pause/Resume Script End If End If Perform Find (Replace Found Set) If(Status(CurrentError) = 401) Loop (repeated retrys or exit are allowed here) End Loop End If Go to Record/Request/Page (Last) Set Field (g_user instructions, "") wlewnka2@hotmail.com

Wish I could help you, I am having the same problem. Have you found a solution yet? Bill F.

I can sympathise with you, as I have encountered the same problem (still unsolved). Since you posted your message some months ago, I was wondering if you had managed to solve the problem yet... I am running FM Server 5.5 on a WinNT box, and a scripted export of summary data to a temporary (fmp) file with replace no dialogue. Sometimes it works, and sometimes it doesn't. I have reset the script so many times I can't count. Thanks. Bill Franklin