Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameterized View of an Oracle Date Field
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00204813
Message ID:
00204991
Vues:
26
Mark,

I use parameterized views with dates all the time. For example one view has
"Audit_.DATESCHED >= ?pdDateFrom AND Audit_.DATESCHED <= ?pdDateTo". The only thing that I may suggest is look at the passing of a date vs. a character.

You said that "where Oracle_Table_Name.Begin_Date > ?lcBgnDate"
doesn't work, but "...Begin_Date>'10/15/95' " does. I see characters instead of dates in your where clause. If I add hard coded dates to views (which I don't do anymore) I always use the FP syntax {10/15/95} to represent the date.

I hope this helps a little considering all the help you passed along!

Kevin
Kevin Emmrich
www.jkt9000.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform