Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Views parameterized on a date field
I have a view with a single parameter based upon a date field. My problem is that I would sometimes like to pass a parameter that returns all records. I have tried passing an empty date, but that returns only records which contain and empty date field.
When I have views with a single parameter based upon a character field, I am able to pass an empty string and all records are returned. How do get the same result when I am dealing with a date parameter?
Thanks in advance
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