Thanks for quick response!
This is for SQL Pass Through. We have a program that converts the FoxPro data to acceptable to SQL Server. The current code converts the date to a string which is fine for datetime but not small date. I will try out the SQLColumns function.
DLC
>>Is there any way to find out what the data type of a field in SQL Server? I need to program against using DateTime and Small Date for comparisons.
>>TIA!
>>DLC
>
>Dave,
>
>From VFP use can use SQLColumns() with the NATIVE option. The call would look like this:
>
>SQLColumns(hConnect, 'tablename', 'NATIVE')
>
>SQLColumns() will return a result set that contains one row for each column in then table.
>
>BTW, The VFP engine will convert both datetime and smalldatetime to VFP's datatime datatype.
>
>-Mike