28 Mar
2021
28 Mar
'21
3:07 p.m.
Message posté par : Dizzy84
----------------------------------------
trop fort, merci.
j'ai corrigé mais il reste une erreur qui là aussi me laisse perplexe:
"near "THEN": syntax error"
pourtant il n'y a pas de virugule dans la syntaxe when then else, non?
je suis preneur de toutes suggestion,
merci d'avance.
le code avec les correcions de Sylvain est maintenant:
SELECT
"Distance","Var","geometry",
CASE
WHEN "Distance" <
(Min("Distance")+(1*((max("Distance")-min("Distance"))/19))
THEN '01'
WHEN "Distance" <
(Min("Distance")+(2*((max("Distance")-min("Distance"))/19))
THEN '02'
WHEN "Distance" <
(Min("Distance")+(3*((max("Distance")-min("Distance"))/19))
THEN '03'
WHEN "Distance" <
(Min("Distance")+(4*((max("Distance")-min("Distance"))/19))
THEN '04'
WHEN "Distance" <
(Min("Distance")+(5*((max("Distance")-min("Distance"))/19))
THEN '05'
WHEN "Distance" <
(Min("Distance")+(6*((max("Distance")-min("Distance"))/19))
THEN '06'
WHEN "Distance" <
(Min("Distance")+(7*((max("Distance")-min("Distance"))/19))
THEN '07'
WHEN "Distance" <
(Min("Distance")+(8*((max("Distance")-min("Distance"))/19))
THEN '08'
WHEN "Distance" <
(Min("Distance")+(9*((max("Distance")-min("Distance"))/19))
THEN '09'
WHEN "Distance" <
(Min("Distance")+(10*((max("Distance")-min("Distance"))/19))
THEN '10'
WHEN "Distance" <
(Min("Distance")+(11*((max("Distance")-min("Distance"))/19))
THEN '11'
WHEN "Distance" <
(Min("Distance")+(12*((max("Distance")-min("Distance"))/19))
THEN '12'
WHEN "Distance" <
(Min("Distance")+(13*((max("Distance")-min("Distance"))/19))
THEN '13'
WHEN "Distance" <
(Min("Distance")+(14*((max("Distance")-min("Distance"))/19))
THEN '14'
WHEN "Distance" <
(Min("Distance")+(15*((max("Distance")-min("Distance"))/19))
THEN '15'
WHEN "Distance" <
(Min("Distance")+(16*((max("Distance")-min("Distance"))/19))
THEN '16'
WHEN "Distance" <
(Min("Distance")+(17*((max("Distance")-min("Distance"))/19))
THEN '17'
WHEN "Distance" <
(Min("Distance")+(18*((max("Distance")-min("Distance"))/19))
THEN '18'
ELSE '19'
END
FROM "TableVario"
----------------------------------------
Le message est situé https://georezo.net/forum/viewtopic.php?pid=341833#p341833
Pour y répondre : geomatique(a)ml.georezo.net ou reply de votre messagerie
Pour vous désabonner connectez-vous sur le forum puis Profil / Abonnement
--
Association GeoRezo - le portail géomatique
https://georezo.net