>I thought I would use DBGETPROP to determine the Data Type of a field in a table. Am I correct in my recent conclusion that you cannot do this ... you can only use DBGETPROP to determine the Data Type of a field in View?
>
>How do I go about getting the Field Type of a field in a table?
>
>Thanks,
>Paul
In addition to what Dorris said, you could use either VARTYPE() or TYPE().
? VARTYPE(mytable.fldname)
? TYPE('mytable.fldname)
George
Ubi caritas et amor, deus ibi est