Re: ADOX in vb6 and access97


"Ricardo Furtado" <RicardoFurtado@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:6615A91D-5774-482E-A69C-F8ED78C70A5A@xxxxxxxxxxxxxxxx
Thank you for your answer
well i'm searching every possibility,...

I found bugs in the code
i just can't do something like
col.Type = myTable.Columns.Item(intContador).Type

because col.Type is readonly
but if i can't do this, how can i change this property?


Some types can't be changed so you can do it in several steps
1) capture the Type of the Field in the existing table.
2) create a new Field in the new table using the information
3) Copy data from old Field to new Field
4) Delete original field
5) Rename new field

But take a look at the ALTER TABLE and DDL with DAO.

As Bob said, this stuff is just easier with DAO.

-ralph


.

Relevant Pages

  • Re: Portable Allegroserve and SBCL
    ... tracking down errors and bugs in large pieces of code that I did not ... Searching through the candidate file to find something related to ... backtrace to figure out whether it's a compiler error or a load error, ...
    (comp.lang.lisp)
  • Re: SOT: Sort of On--Discussing Mysteries
    ... hints that help unravel the mystery. ... reference I thought was ... I'm always searching back to see if I remember a fact ... it bugs me and I have to figure out why. ...
    (rec.arts.mystery)
  • Re: [SLE] k3b issues
    ... is lightning fast compared to 0.10 rpm version and lot's of bugs out ... (dao, cdrdao, it alway kept making some error messages). ...
    (SuSE)
  • Print services in Solaris 10
    ... without problems, using Solaris 10? ... Searching around, all I see are ... reports of bugs and people moving to CUPS instead. ...
    (comp.unix.solaris)
  • Re: Congrats to Dr. Wagner!
    ... NY Times review of David L. Wagner's new book, ... He has made a career out of searching for insects and ... bugs under fallen trees and log piles, while I spend my time searching ... for defects and bugs in source code and logfiles. ...
    (sci.crypt)