Information générale
Titre:
SPT and date fiields
Hi
I am reprograming some parts of VFP Aplication on SQL Server Back end. In some cases I use SPT
instead remore view. With remote view I use DBSETPROP() for automatic conversion from Datetime to
Date format.
DBSETPROP('DBOrder.OrderDate','FIELD','DATATYPE',"D")
DateTime from SQL Server is avtomaticly converted to VFP date type.
Now I would like to do conversion also in resulting cursor after Select statement. Is it possibile?
Thisform.grid1.Date.controlsource="TTOD(Result.OrderDate)" is not sending canges back to SQL Server
Regards
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement