Bug #791
closed[810] :Final picklist values -- decide and agree on them
0%
Description
Check with NRIS db for applicable picklists
Files
Related issues
Updated by Michael Lee almost 22 years ago
This is the xml document created from MS Access that shows the current closed
list values. The values will change in the next few weeks, perhaps even
months, however.
Updated by Michael Lee almost 22 years ago
this csv document is simply a translation of the xml, as per John's request.
Updated by Michael Lee almost 22 years ago
This new document should be more useful in that it includes sort order, value
desctipion, table and field (explicitly) as well as the source table (in
VegBranch). VBA script that generates this will soon be posted.
Updated by Michael Lee almost 22 years ago
This is the VBA code that generates the XML doc. It must be embedded in a
VegBranch database to work, OR:
Have tables named like: aux_table_field where table is the name of the table
and field is the name of the field that has a closed list
''There must also exist a Z_FieldDescription table in the database which
documents which fields have closed lists
''As well as a query Z_FieldDescriptionOrd, which includes a table:
misc_SQL_2AccTypes which translates "access" data types into "SQL" types
Updated by Michael Lee almost 22 years ago
- Bug 790 has been marked as a duplicate of this bug. ***
Updated by Michael Lee almost 20 years ago
changed from components that are to be deleted to "misc" so that bugs don't get
deleted with component. Sorry for all the email.