Information générale
Catégorie:
Codage, syntaxe et commandes
>Hi CG,
>>>Can you post a SQL statament that the view builder creates?
>>>You can get to it by clicking on SQL batton on View designer toolbar.
>>
>>-------------
>>SELECT Pyoutbak.int06, Pyoutbak.c40_01, Tlkppaf.name, Pyoutbak.date01,;
>> Pyoutbak.datm06;
>> FROM sys2core!pyoutbak LEFT OUTER JOIN sys2core!tlkppaf ;
>> ON Pyoutbak.int01 = Tlkppaf.int01;
>> WHERE Pyoutbak.int06 <> 0;
>> AND TTOD(Pyoutbak.datm06) <= "gd_start"
>>---------------------
>>
>>Well that shows the problem...the sql is adding quotes around a date variable making it a literal. Any ideas?
>>
>>
>>CG
>PMFJI,
>Put a question mark ahead of gd_start and define it in the View Parameters as a Date.
>HTH,
Worked like a charm! Thanks Everyone! A lot____.
CG
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