Hi All,
I am designing a table that will be populated primarily by using a configuration package (Rapidstart). This will be done regularly, not just for the initial set of data. Some of its fields should not allow blank values, but I have not been able to find a way to enforce this when importing data. I would like the configuration package to throw an error if the mandatory fields are blank in the package data. (Currently my package loads the blank values without error). Does anyone know of a way to achieve this? Or should I look at an alternatives such as XMLPorts?
I have tried doing the following in the table's definition :
- NotBlank = true : but this is only respected by pages
- Put Testfield() in the fields' OnValidate() trigger : but this does not work because when the field's value is empty, OnValidate() is not called.
- Check the fields' values in the table's OnInsert() and OnModify() trigger : but this does not work because on the initial insert, the fields' values are not yet populated, so are legitimately blank. This method can work with inserts from the page, by using DelayedInsert, but DelayedInsert is not available for inserting data via a configuration package.
Perhaps I've missed something.
Thank you in advance.
Chris
