OleDbSchema ... Possible to get type of "View/Query" ? 1

[ZmrAbdulla]

I am trying to get details of an Access DB thorugh "OleDbSchema".

DB_Connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, _
       New Object() {Nothing, Nothing, Nothing, "VIEW"})

Is that possible to get type of Query(View) through this?

I need to know what type of query is that (Select/Delete/Update/Union etc..)

Thanks

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[Mastakilla]

If I remember well, this "GetOleDbSchemaTable" returns a table with several columns, one of wich contains the sql text of the query. You can check whether this text starts with "SELECT " or "DELETE " or "UPDATE " or if it contains a " UNION SELECT " etc ....

Hope this helps somehow.

---
[tt][COLOR=white Black]MASTA[/color][COLOR=Black lightgrey]KILLA[/color][/tt]

 

[ZmrAbdulla]

I can't find any column contains SQL text though it returns 14 columns.
TABLE_CATOLG
TABLE_SCHEMA
TABLE_NAME
TABLE_TYPE
TABLE_GUID
BOOKMARKS
etc...

can you please make sure it has

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[ZmrAbdulla]

I think I need to query system tables to find out..
I will try it tomorrow. time to leave now.

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[Mastakilla]

OK,

try this then:

DB_Connection.GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Views, _
       New Object() {Nothing, Nothing, Nothing})

It will return a table with the views' information, check out column VIEW_DEFINITION. I can already see the big happy smile on your face !

---
[tt][COLOR=white Black]MASTA[/color][COLOR=Black lightgrey]KILLA[/color][/tt]

 

[ZmrAbdulla]

Excellent..

But..Queries other than SELECT won't be shown in the list.


________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[ZmrAbdulla]

Found it..

DB_Connection.GetOleDbSchemaTable(OleDbSchemaGuid.[COLOR=red][b]Procedures[/b][/color], _
         New Object() {Nothing, Nothing, Nothing})

________________________________________________________
Zameer Abdulla
Help to find Missing people