Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SPT and date fiields
Message
De
08/05/2002 10:13:17
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
SPT and date fiields
Divers
Thread ID:
00653980
Message ID:
00653980
Vues:
57
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
Fil
Voir

Click here to load this message in the networking platform