How to set property 'Notation' of an MS Access field from within Delphi?
Posted on 2007-03-19
To update the MS Access database of my application I use following statement.
QSQLDB.SQL.Text:='ALTER TABLE FacturenUIT ADD COLUMN IsCorrect Bit DEFAULT True';
This will add field IsCorrect to the database table.
I also can set the default value for the field by adding 'Default True' as you can see above.
For boolean values I can set the notation (F6) in MS Access (like: 'Yes/No', 'True/False' or 'On/Off')
How can I set the notation from within Delphi?