Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Indexing on datetime field
VFP 5.0 SP3/Win 95/NT Network
I have a transactional table with an EventDate column defined as DateTime and some informational columns. There is regular index defined on the EventDate column.
I have a report where the user specifies a first and last date. I filter using
"SET FILTER TO BETWEEN(TTOD(EVENTDATE),LLODATE,LHIDATE)".
There are 2 events at the top of the file with the same datetime. The report will show these both sometimes but page-down, page-back will make the first one disappear. My guess is that the index is not distinguishing between these rows.
Any help in making this more consistant will be greatly appreciated. Thanks
-Swen
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement