I have a field, item ID, set to auto enter a serial number and validation set to not empty and unique. If the serial number entered is not unique I do not get an error message when exiting the item ID field. If I turn off auto enter serial number and manually enter a non unique item ID, I do get an error message when I exit the field.
With auto enter a serial number turned on I only get the non unique error message when I commit the record. I would like to get the error message when exiting the field when auto enter a serial number is turned on
Recently I came across the demand to handle a specific file hosted on a FMS from an other, externally opened FM-file.
Utilising the BE- or MBS-Plugin I can run system commands on the server from the client as PSOS to e.g. close the file on the FMS or, for instance, create text files.
But to just open the fmp12-file locally in FM 18 or 19 (both are installed) a system command like "cmd.exe /c "/PATH/TO/FILE.fmp12"" does not work as PSOS but worked when run locally.
Since the way, imho, would be to call a system level script on the server from the remote file I'm looking for the right syntax which works as PSOS.
But I'm open to other ways as well ;o)
I have a table with 200,000 plus records. In that table, 1967 records have a BidID of 2018-XXX. Each of those records has an ItemID. Those records are imported from another table. I want to check for duplicates so as to verify the user did not perform the import twice. ItemID is unique.
Here is how I am searching for duplicates
First search for duplicate ItemID by placing ! in itemID field then perform find
Next enter find mode again and place 2018-XXX in bidID field then select constrain found set in Requests menu.
This does not find duplicated contained in 2018-XXX. It does find a subset of only 1248 records however.
If I switch the order, first find BidID then constrain to duplicates, no luck, still finds 1248 records
I have tried many other ways to find duplicates within bidID 2018-XXX with no luck.
Just looking to see if anyone has come across a good solution to for this.
I have a set of records with multiple fields that I need to export to Excel, I'm exporting via script and everything works great with the exception of one of my fields "columns". This field has a multi-line description. When exporting, all carriage returns are stripped. A quick google search turns up some solutions for exporting a single filed and preserving returns but not a group of fields with only one "column" needed the returns preserved.
I'm on FM19 Server.
Is there a plugin that addresses this issue?
I have an application where some of the related files will reside on removable media. When sorting, a message box appears telling the user that the related file (which is not on the server) can not be opened (Not Found) and asks the user to locate it. The related file may or may not be available on the removable media and is not needed for the purposes of the sort.
Is there anyway to prevent this message from appearing? Error capture on does not solve the problem
Who Viewed the Topic