Board index » delphi » ADOX 2.5 - Jet 4.0 Provider - Can't use to set default values for a column
Troy Wolbrink
![]() Delphi Developer |
Sat, 25 Jan 2003 03:00:00 GMT
ADOX 2.5 - Jet 4.0 Provider - Can't use to set default values for a column
After preparing about 600 lines of ADOX code used to set up my database, I
came to the discovery that setting some adox column.properties['Default'].Value seemed to be ignored. When I afterward opened the database in Access there were NO defaults set anywhere! This was confirmed by Microsoft's knowledge base article: When attempting to set the Default property of an ADOX NOTE: This behavior only occurs under ADO 2.5. However, I found a work around by using a TAdoCommand to send the SQL: I can't believe this major flaw in ADOX exists (especially since it worked |