Hi Grigore,

Correct ODBC syntax for this is:

SELECT { fn CONVERT( GETDATE(), SQL_TYPE_DATE ) } date
,  { fn CONVERT( GETDATE(), SQL_TYPE_TIME ) } time
,  { fn CONVERT( GETDATE(), SQL_TYPE_TIMESTAMP ) } datetime 

But SQL Server not support conversion to
SQL_TYPE_DATE and SQL_TYPE_TIME ( read on BOL ).

On ODBC precess it return identical
SQLColAttribute ( VFP use old ODBC api interface )
or SQLDescribeColW ( on SQL Query Analyzer ).

With this values, VFP cannot build a Date field,
because ODBC return always to a SQL_TYPE_TIMESTAMP,
VFP map it to a SQL_C_TIMESTAMP, and build a datetime field.

Then,
if VFPT not implement ( on VFP9 ) a fields definition for spt cursors
( a 4-parameter string for SQLEXEC() and 3- parameters for SQLMORERESULT() ) , like RV and CA ( plus nullable ),
is impossible build a spt VFP cursor with SQL Server as backend.

Fabio