locked
MSFLEXGRID: Adding data

    Question

  • hi guys!
    
    well im having some trouble using the flexgrid. i have this following code:
    
        With MSFGFields
            .Rows = 1
            .TextMatrix(0, 0) = "Field"
            .ColWidth(0) = 1750
            .ColWidth(1) = 1750
        End With
    
    what i want to do is to read a tables COLUMN name and show it into the grid. 
    my code look like this but it doesnt work.
    dont know where the problem is.
    
                Set FieldName = MainConnection.OpenSchema(adSchemaColumns, 
    Array(Empty, Empty, "MyTable"))
                Set MSFGFields.DataSource = FieldName
            
                Do While Not FieldName.EOF
                    MSFGFields.AddItem FieldName!COLUMN_NAME
                    FieldName.MoveNext
                Loop
    
    do any of you have any ideas solving this problem? that will be great! thanks!
    
    --novelle
    Tuesday, October 31, 2006 8:36 AM