ADOX Catalog view

  • Thread starter Thread starter deepdiver
  • Start date Start date
D

deepdiver

I append a view with ADOX Catalog and View object to an access 2000
database, the object can be used but is completly hidden?
 
Are you talking about a view involved tables in a Jet database (i.e. an
MDB), or in some other RDMS? If it's Jet, you're far better off using DAO
than ADOX.
 
Are you talking about a view involved tables in a Jet database (i.e. an
MDB), or in some other RDMS? If it's Jet, you're far better off using DAO
than ADOX.
Click to expand...


Yes i am talking about views using tables in a jet database.

This more or less well known code works fine with the exception that
these created views are not visible, but can be used.

ADOX::Catalog ^cat = gcnew Catalog();
cat->Create(this->ConnStr);
ADODB::Command ^adocmd = gcnew ADODB::Command;
adocmd->CommandText = "SELECT settings.* FROM settings;";
cat->Views->Append("hugo",adocmd);

thx & kr/Werner Broser
 
Yes i am talking about views using tables in a jet database.

This more or less well known code works fine with the exception that
these created views are not visible, but can be used.

                ADOX::Catalog ^cat = gcnew Catalog();
                cat->Create(this->ConnStr);
                ADODB::Command ^adocmd = gcnew ADODB::Command;
                adocmd->CommandText = "SELECT settings.* FROM settings;";
                cat->Views->Append("hugo",adocmd);

thx & kr/Werner Broser
Click to expand...


i think i found it, it is per design
msdn says a view created with adox or create view statement (which
should be possible with jet 4, but is not)
does not appear in the interface.
 
Back
Top