PDA

View Full Version : CodeMast



DaveR
24-Mar-2022, 02:52 PM
1. Why doesn't codemast (out of the box) have an index.2?:confused:

Type
description
Code (for uniqueness)

Much better to let users search by description (this has bugged me since I first started DF) ISO country codes are a classic example of the code sometimes being out of step with the country name.

2. Who has replaced Codemast with their own file? And if you did, did you just edit the filedef and rely on the DAW-supplied classes, or subclass and improve them, or start again from scratch?

Richard Hogg
24-Mar-2022, 04:21 PM
Hi Dave,
It's been a long time since I've used it but I seem to remember we replaced codemast with dedicated tables for each code type because we found codemast too difficult in complex systems for all sorts of reasons, customising, external reporting tools etc etc. I can see advantages of using it in some instances though.
Cheers

Samuel Pizarro
24-Mar-2022, 04:42 PM
I don't use them..

I create dedicated tables for each use case.
And for validation support, i use the built-in filevalidation class.

This way you can have additional columns in the base table to support business needs, like if the code is active, by date or just a simple boolean, also you can have different data types for the codes and bigger descriptions.

And the most important, way easier to relate things for reporting.

Regards