Re: renaming an mdb table from D7 using ADOX

From: adze (adze_at_no.mail.please)
Date: 12/29/03

  • Next message: Bill Todd (TeamB): "Re: swapping two values in db" 
    Date: Mon, 29 Dec 2003 18:19:42 +1100

    >DRS wrote:
    > http://codecentral.borland.com/codecentral/ccweb.exe/listing?id=15292
    > It doesn't rename a table but it should be more than enough to get you going
    > with ADOX. Add Variants to the uses clause for D6 and higher.

    Thanks for that David. It worked a treat and I can now rename
    tables using ADOX_TLB/ADODB_TLB. I have hit another snag though.
    I was previously doing a table definition using SQL similar to:

       DoSQL(Query,'CREATE TABLE ' +TableName +'('
         +' ,fldBitmap OLEOBJECT '
         +');');

    But using your techniques, I can't find a suitable value in
    DataTypeEnum for this column type (ie, adOleObject or similar).
    Do you have any suggestions please?

    regards, adze

  • Next message: Bill Todd (TeamB): "Re: swapping two values in db"

    Relevant Pages

    • Re: rename a column i Access
      ... Where did you find the RENAME keyword? ... ALTER TABLE DatoCurrency ADD COLUMN NewName datatype ... You can use ADOX to rename a column. ... This email account is my spam trap so I ...
      (microsoft.public.inetserver.asp.db)
    • Re: rename a column i Access
      ... thanks for You answer - I can´t remember where I found the rename. ... But I followed Your example with changing the driver to JET and now my ... > ALTER TABLE DatoCurrency ADD COLUMN NewName datatype ... > You can use ADOX to rename a column. ...
      (microsoft.public.inetserver.asp.db)