Menu ▾ ▴

#4 TAccessDbCreator does not set column default values

open
nobody
DbCreator (6)
2026-09-27
2026-09-27
No

TAccessDbCreator.CreateColumn (dbcreator/u_dzDbCreatorCreateAccess.pas) assigns ComColumn.Properties['Default'].Value := _Column.DefaultValue, and the author's own TODO says: "This apparently doesn't work, at least not for text and integer fields." So an Access database created from a description with default values does not have them.

The cause has not been looked into. One thing to try is whether ADOX for Jet expects the default as an expression string (a text default in quotes) rather than a variant of the column's type.

Also tracked as issue 133 in dzlib's ISSUES.md.

Discussion


Log in to post a comment.