Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Date default value in sqlserver
Message
De
07/09/2007 15:26:27
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
07/09/2007 13:02:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01253060
Message ID:
01253104
Vues:
24
>i use sqlserver 2000 and i noticed that when date is empty, sqlserver fills it with 01/01/1900
>how to have vfp " / / " empty date when receving datas from sqlserver ?

Assuming you're using SPT or readwrite views:

Blank fields mydate where mydate={^1900-01-01}

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform