Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Statement Logic
Message
De
15/02/2008 15:06:32
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
 
 
À
15/02/2008 14:37:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01292989
Message ID:
01293066
Vues:
15
I got to it before reading your post, but that's exactly what was needed. Thanks!

>A couple of ideas:
>
>1. It might simplify things if you can convert the separate date and time variables into DateTime variables
>
>2. I haven't looked at your code too closely, but I've had similar time span logic cases to deal with in the past. The logic I use is:
>
>- all or part of my test time span A is in time span B if:
>
>- either A.Start or A.End is between B.Start and B.End, OR
>- A.Start < B.Start AND A.End > B.End
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform