Actually I was wanting to know if the field had an index on it...I got something to work - I'm gonna clean it up some and maybe pass it on to Doug, it's really quite slick I think...<g>.
>Get what info, Victor? IF you mean the field names then FCOUNT() and FIELD() will do that for you. Cycle through the fields with FCOUNT() and get the name with FIELD(). You can then use EVALUATE() to see what type of data each field is and adjust the column data Format and whatnot appropriately.
>
>
>>Hi all....
>>Ok...here's the idea...I want to automate this somehow so I can use the same grid for all my tables....
>>
>>
>>If AllTrim(Upper(This.RecordSource)) = "MRKTGCAT"
>> CURSORSETPROP('buffering',3,'MRKTGCAT')
>> With THIS
>> .iaColumnInfo[1,3] = "mrktgcat"
>> .iaColumnInfo[2,3] = "abbrev"
>> .iaColumnInfo[3,3] = "catorder"
>> EndWith
>>EndIf
>>
>>
>>
>>I will know the table name...the dbcxgetprop should be able to give me this info somehow, eh? anyone know how?
>>
>>Thanks!
ICQ 10556 (ya), 254117