Hello, I want to change the size of a field programmatically with ADOX. The MSDN doc says that the DefinedSize property of a Column object can only be changed for columns that are not yet bound to a table. The example does it by creating a new field with the new size. In that case I must rename the old field, create the new field, copy the data and drop the old, renamed, field... As a side effect, the column order is changed. Not a big deal, but yet undesired.
The underlying database is MS Access. In MS Access I can use the ALTER TABLE statement to simply change the field size. But the whole point of using ADOX is to make the thing less database platform dependent by not using SQL directly. Is there any easier way to do this with ADOX, without the juggling with columns I described above? Thanks, Peter Laman Senior Software Engineer Lance ICT Group Roermond, the Netherlands http://www.lance-safety.com "I know you believe you understand what you think I said, but I am not sure you realize that what you heard is not what I meant." Alan Greenspan _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://www.elists.org/mailman/listinfo/delphi-db
