8000 Name 158 more form properties, with their purposes from Microsoft's reference by dominion525 · Pull Request #109 · dominion525/jetdb · GitHub
[go: up one dir, main page]

Skip to content

Name 158 more form properties, with their purposes from Microsoft's reference - #109

Merged
dominion525 merged 3 commits into
mainfrom
feature/more-prop-names
Oct 22, 2026
Merged

dominion525 merged 3 commits into
mainfrom
feature/more-prop-names

Conversation

@dominion525
Copy link
Copy Markdown
Owner

Summary

  • Name each unnamed property ID up to 0x01C4 whose values are all held by one SaveAsText key, and no other, in the forms and reports of Sports.accdb and of the generated databases in both formats: 55 of text, 94 of numbers and Yes/No, and 9 of bytes and GUIDs. A Yes/No stored without a value (NotDefault) and a double are named by number_prop_id_name, and bytes and GUIDs by the new bytes_prop_id_name
  • The SaveAsText test agrees NotDefault and numbers as one kind and checks at least 217 named IDs; the tests of jetdb-wasm and smoke.mjs find these properties by their names
  • Keep the names in constant tables sorted by ID and look them up by binary search, so that more names add no complexity
  • docs/form-design (en/ja) gives the names in three tables, with the purposes from Microsoft's Office VBA reference for Access (MicrosoftDocs/VBA-Docs, CC BY 4.0): the English first sentence, and the Japanese name in the Properties window or the first sentence of the Japanese page; the keys the reference does not describe are marked so

🤖 Generated with Claude Code

dominion525 and others added 3 commits October 21, 2026 17:14
- Name each unnamed ID up to 0x01C4 whose values are all held by one key, and no other, in the SaveAsText output of the five databases: 55 of text, 94 of numbers and Yes/No, and 9 of bytes
- Name a Yes/No without a value (NotDefault) and a double, such as RecSrcDt, by number_prop_id_name, and bytes and GUIDs by the new bytes_prop_id_name
- Agree NotDefault and numbers as one kind in the SaveAsText test, being the same Yes/No properties, and raise its floor of named IDs to 217
- Find by their names the properties the tests of jetdb-wasm and smoke.mjs found by number, and check that an unnamed ID is given by number with 0x0250

Co-Authored-By: Claude Opus 5.5 (1M context) <noreply@anthropic.com>
…t's reference

- Give the names of form-design (en/ja) in three tables, of text (95), number and Yes/No (114) and bytes (9) values, as the library names them
- Take the purposes from the pages of form, report and control properties in Microsoft's Office VBA reference for Access (MicrosoftDocs/VBA-Docs, CC BY 4.0): the first English sentence, and the Japanese name in the Properties window or the first sentence of the Japanese page; mark the 32 keys the reference does not describe, adding only what was found of RecSrcDt and GUID
- Tell how the names are chosen and where the purposes come from, and drop the three named IDs from the table of unknown IDs

Co-Authored-By: Claude Opus 5.5 (1M context) <noreply@anthropic.com>
- The arms of match counted as branches, so prop_id_name, number_prop_id_name and bytes_prop_id_name went over the complexity thresholds with the names added, at 97, 116 and 11
- Keep the names in constant tables sorted by ID, TEXT_NAMES, NUMBER_NAMES and BYTES_NAMES, and look them up with name_in by binary search, so that each function is one line and more names add no complexity
- Test that the tables are sorted by ID without repeats; the names stay the same

Co-Authored-By: Claude Opus 5.5 (1M context) <noreply@anthropic.com>
@dominion525
dominion525 merged commit eaf1e61 into main Oct 22, 2026
10 checks passed
@dominion525
dominion525 deleted the feature/more-prop-names branch October 22, 2026 02:39
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant

0