OpenSchema

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi

I am using below statement to get the list of all the columns by table.

Set objRs = objConn.OpenSchema(adSchemaColumns, Array(Empty, Empty,
strTableName, Empty))

This statement returns me all the columns. No problem.

How can I restrict that only columns with data type number or floats or
integer should be returned....I have hard time setting up the filter
criteria...

can somebody help me





.

Relevant Pages

  • Re: Query to get Table schema
    ... Set objDB = Server.CreateObject ... objDB.Open sDBName ... 'Set objRS = objDB.Execute ... empty, "Y O U R T A B L E N A M E ")) ...
    (comp.databases.ms-access)
  • RE: Adding info to query
    ... I'll try and give you an example to what I mean, it could be that the prev ... also, what if the first record is empty, there will be no previous record. ... Function LookForLastDate(IdFieldName As Double, DateFieldName As Variant) ... >>> Mike J ...
    (microsoft.public.access.queries)
  • RE: Adding info to query
    ... it sort of makes sense now. ... > compile error. ... >>> also, what if the first record is empty, there will be no previous record. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • RE: Adding info to query
    ... >> I'll try and give you an example to what I mean, it could be that the prev ... >> also, what if the first record is empty, there will be no previous record. ... >> DateFieldName),Date) As DifferentInDays From TableName ... >> LookForLastDate = DateFieldName ...
    (microsoft.public.access.queries)
  • delete rows from datagrid
    ... My problem is that whatever rows I delete, dgDeleted is always empty ... What should I do to store the deleted rows in a dataset so i can ... Thx ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)