Information générale
Catégorie:
The Mere Mortals Framework
Importance: Normal
To get all dates, you'd need to populate the from and to date parameters
with dates outside the range of dates you expect in the data. Note that
this technique will not work if you use .NULL. instead of {} for empty
dates, which might be the case in SQL Server date fields.
Rob
|
|
|
| >Hi!
| >
| >Regards from Mexico!
| >
| >I have two questions:
| >
| >1.- By default the Ctextbox class, eliminate the left spaces,
| how can I do for not?
| >
| >2.- I have a parameterized view, with 'LIKE' comparison, so I
| can put '%' in the value's parameters. But now, I have a
| parameter type DATE, so how can I do to find every date?
| >
| >Thanks a lot!
|
| Hola Gavilán,
|
| I don't understand your first question. For the second, you can
| use dates easily in view parameters, like this:
| BETWEEN (dEcheance, ?vp_dBeg, ?vp_dEnd) or dEcheance < ?vp_dBeg.
| Simply don't forget to define your parameters as DATE type.
|
| José
|
Précédent
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