Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Function empty() and null value
Message
 
 
À
28/06/2011 12:50:10
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01516146
Message ID:
01516547
Vues:
53
>>>>I think your approach is probably better. Except a little more characters to type when making changes <g>. Thank you.
>>>
>>>You can always pass the var to a function and check it there - you could set it to an empty date if it's null or check it for a valid date within a range if it's not null, etc....
>>>
>>
>>Good suggestion. I can add more "features" to the function that checks for empty or null date. Thank you
>
>Except that I'd still go for the one-liner expression in a SQL statement. Today's machines may be fast enough for that, but still the overhead of calling a function for each record may be too much - and may get of your nerves if it happens while debugger is on.

My purpose of using the "empty" expression is not in the SQL statement.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform