ADOX Catalog view

[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?

 

[Douglas J. Steele]

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.

 

[deepdiver]

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.

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

 

[deepdiver]

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

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.