Bonjour,

Je souhaite inserer une variable dand une vue.

Celle-ci doit faire référence à un champ date.

Ci dessous la requete avec en rouge la variable correspondant au champ date)



Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
CREATE VIEW NEW_VIEW15(
       ECKTSOC,
       ECKTNUMERO,
       ECCTNOM,
       ECCJCRE,
       LCKTNUMERO,
       LCCJDEREX,
       LCCTSOLACE,
       LCKTSOC,
       LCCTCODE,
       LCCTSOLACC,
       LCCJDERCO,
       LCCTNATURE
) AS 
select ECOMCLI.ecktsoc, ECOMCLI.ecktnumero, ECOMCLI.ecctnom, 
  ECOMCLI.eccjcre, LCOMCLI.lcktnumero, LCOMCLI.lccjderex, 
  LCOMCLI.lcctsolace, LCOMCLI.lcktsoc, LCOMCLI.lcctcode, 
  LCOMCLI.lcctsolacc, LCOMCLI.lccjderco, LCOMCLI.lcctnature 
from ECOMCLI, LCOMCLI 
where (
  ECOMCLI.ECKTSOC = LCOMCLI.lcktsoc 
  AND ECOMCLI.ECKTNUMERO = LCOMCLI.LCKTNUMERO 
  AND LCCJDEREX > LCCJDEREX 
  AND ECCJCRE < LCCJDEREX 
  AND LCCTSOLACE = 'S' 
  AND LCCTNATURE <> '7' 
) OR (
  ECOMCLI.ECKTSOC = LCOMCLI.lcktsoc 
  AND ECOMCLI.ECKTNUMERO = LCOMCLI.LCKTNUMERO 
  AND  ECCJCRE < LCCJDEREX 
  AND LCCTSOLACE <> 'S' 
  AND LCCTNATURE <> '7' 
) OR (
  ECOMCLI.ECKTSOC = LCOMCLI.lcktsoc 
  AND ECOMCLI.ECKTNUMERO = LCOMCLI.LCKTNUMERO 
  AND LCCTNATURE <> '7' 
  AND LCCTCODE = 'CL1414' 
  AND LCCTSOLACC <> 'S' 
  AND ECCJCRE < LCCJDEREX
) OR (
  ECOMCLI.ECKTSOC = LCOMCLI.lcktsoc 
  AND ECOMCLI.ECKTNUMERO = LCOMCLI.LCKTNUMERO 
  AND LCCTNATURE <> '7' 
  AND LCCTCODE = 'CL1414' 
  AND LCCTSOLACC = 'S' 
  AND ECCJCRE < LCCJDEREX 
  AND LCCJDERCO > LCCJDEREX
)

Peut on utiliser un champ comme variable,comment le declarer ?

Merci.