I know that the custom validation error dialogs don't show up through IWP, so I've been using scripts to serve as field validations and modify a blank field (a global variable that I update via the scripts) to tell the user what the validation problems are.

Is there some way that I can "export" the validation conditions that I've set on the database as scripts, so that I could check them (and be able to give appropriate feedback) through IWP? Or would I need to create such validation scripts to account for IWP? It's one thing if we only have a handful of condition to check...a different matter if we have a lot.

I suppose it's possible to not bother setting the validation on the fields and do it all direct by scripting...

Any insight is appreciated. Thanks.

...and modify a blank field (a global variable that I update via the scripts)

Well, which is it, a field or a variable? Or do you meaqn that you place the contents of a variable into a field?

Is there some way that I can "export" the validation conditions that I've set on the database as scripts...

Hard to say what you mean by this, but you can certainly print the database definitions to PDF then cull out the validation conditions to get a document that summarizes conditions per field of a table.

If you're creating scripts to handle validation, that will help, but it won't do all the work for you, if that's what you were hoping.

I suppose it's possible to not bother setting the validation on the fields and do it all direct by scripting...

If you do that, I suggest you use a script that branches and posts a conventional custom dialog when running on a client workstation, but posts an alert to a global field (clearing it later) when running in IWP.

That way you have one main validation process (same checks, same error message text) that branches to deal with user feedback requirements in the two environments. :wink2:

Sorry, I guess I wasn't clear enough.

In my table, I have an extra field that is declared a global field. Using scripts, I'm writing things into that field for user feedback, which was basically what you suggested towards the end of your post. I was just wondering if there is an easier way, because I would be writing two copies of validation...one for the client, the other for the IWP.

Thanks for the confirmation though. It seems like I'm thinking down the right now.