Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Datetime fields Null and empty
Message
De
27/01/2009 11:36:20
Bruno Maddalozzo
Informatica Aziendale
Arsie, Italie
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Datetime fields Null and empty
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Vista
Database:
MS SQL Server
Divers
Thread ID:
01377360
Message ID:
01377360
Vues:
48
I'm upsizing an application which now uses local views to use remote views (but only in some installations, where network traffic is intensive and the application now is too slow) to access SQL Server data, depending on the DBC distributed, which will contain only local views or remote views.
The goal is to change as less code as possibile.

The problem I'm facing is about Datetime fields.
In code I often refer to them testing for their EMPTY() value (not ISNULL()) and store them as empty datetime values.
I can now send (Upload) NULL value to SQLServer tables, using the Properties button in the remote view designer with default = NULL.

I'm asking now for a speedy way to test for NULL values in data 'Downloaded' from SQL and convert them in Empty values {//::} so as leave most of code unchanged.

TIA.
Bruno
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform