>when i send data from sqlserver to vfp all dates fields become datetime. i want them to be date type.
>is it possible change the type of a field by code whithout showing the table designer ?
If you use RV you could click on Field in View designer then Map DateTime field to Date field.
If you use CAs you could use CursorSchema property to map that field to Date one.
If you use SPT, no easy way. You could get the result set from SQL Server and then run new select:
SQLEXEC(...,...,[crsTemp])
SELECT ...,
TTOD(MyDateTimeField) AS MyDateTimeField;
FROM crsTemp;
INTO CURSOR RealCursorName
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.