Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>Hi Body
>>>
>>>I make a parameters view on a date field. when i define the variable before i use the view all work fine but when i let popup the dialog box who ask value of the variable it always give me bad date format.
>>>
>>>Do you know what i suppose to type to specify a date format?
>>>
>>>_____________________________________________________________
>>>
>>>CREATE SQL VIEW "TOTO" ;
>>> AS SELECT Nofacture ;
>>> FROM mp_data!Test ;
>>> WHERE DateDu <= ?pdvDate1
>>>____________________________________________________________
>>>
>>>Thank's in Advance
>>>Rock
>>
>>DId you try typeing the date in Curly Braces? {01/01/99}.. if you have stricdate set to 2 or 3 you will (may) need to use strict date {^1999-01-01}
>>
>>BOb
>
>Hi Bob
>
>If i set SET STRICTDATE to 0 {1999-01-01} work fine
>But if I set STRICTDATE to 1 {^1999-01-01} give me Strict Date Error.
>
>Do you Have another thing to try ?
>
>Rock
You are correct sir... I don't know why that does that... but, when I set stricdate to 2 and do this...
vp_dateparam = {^1999-01-01}
use myview
It works fine... perhaps you need to prompt for the date with your own form setting the StrictDate property of the textbox as you see fit. Don't know why this doesn't seem to work.
BOb
Précédent
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