Re: [sqlite] using sqlite calculated field

[Kees Nuyt]

On Sun, 18 Dec 2011 21:20:00 -0300, Esteban Cervetto
 wrote:

>  END) AS 'INDEM'

INDEM should not be quoted.

Single quotes are used for text literals. If you want to quote
identifiers (e.g. because they are keywords) use backticks `identifier`
or double quotes "identifier" or brackets [identifier].

There is not much we can say about your query without the schema, sample
data, error messages (if any), actual result set and expected result
set.

-- 
Regards,

Kees Nuyt

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] using sqlite calculated field

[Esteban Cervetto]

this solution works, but it is very messy:

SELECT
  datsiniestros.grupo,
  datsiniestros.siniestro,
  datsiniestros.ibm,
  datsiniestros.edad,
  datsiniestros.porinc,
  datsiniestros.sexofem,

  /* (CASE sexofem
WHEN 'False' THEN parrentas.masc_ippd
ELSE parrentas.fem_ippd
  END) AS IPPD,
  (CASE sexofem
WHEN 'False' THEN parrentas.masc_iptd
ELSE parrentas.fem_iptd
  END) AS IPTD,*/
  (
CASE grupo
  WHEN 2 THEN 0 /*RECHAZOS*/
  WHEN 3 THEN 0 /*LEVES*/
  WHEN 4 THEN
(53*porinc*100*ibm*65 /datsiniestros.edad) /*O-50*/
  WHEN 5 THEN
(53*porinc*100*ibm*65 /datsiniestros.edad) /*O-50*/
  WHEN 6 THEN
(53*porinc*100*ibm*65 /datsiniestros.edad) /*O-50*/
  WHEN 7 THEN
(53*porinc*100*ibm*65 /datsiniestros.edad) /*O-50*/
  WHEN 8 THEN
(53*porinc*100*ibm*65 /datsiniestros.edad) /*O-50*/
  WHEN 9 THEN
(
  ibm* (CASE sexofem
WHEN 'False' THEN parrentas.masc_ippd
ELSE parrentas.fem_ippd
  END)+8
) /*5O-66*/
  WHEN 10 THEN
(53*ibm*65 /datsiniestros.edad + 10) /*>66*/
  WHEN 11 THEN
(
  53*ibm*65 /datsiniestros.edad + 10+2000*1.25* (CASE sexofem
WHEN 'False' THEN parrentas.masc_iptd
ELSE parrentas.fem_iptd
  END)
) /*GI*/
  WHEN 12 THEN
(53*ibm*65 /datsiniestros.edad + 12) /*MUERTE*/
END
  ) AS 'INDEM'
FROM datsiniestros
  INNER JOIN parrentas ON
(datsiniestros.edad = parrentas.edad);
>
>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] using sqlite calculated field

[Esteban Cervetto]

this query fail:
Because I am trying to use the IPPD calculated field. How can i do this?
Thanks


SELECT
  datsiniestros.grupo,
  datsiniestros.siniestro,
  datsiniestros.ibm,
  datsiniestros.edad,
  datsiniestros.porinc,
  datsiniestros.sexofem,

  (CASE sexofem
WHEN 'False' THEN parrentas.masc_ippd
ELSE parrentas.fem_ippd
  END) AS IPPD,
  (CASE sexofem
WHEN 'False' THEN parrentas.masc_iptd
ELSE parrentas.fem_iptd
  END) AS IPTD,

  (CASE GRUPO
  WHEN  2 THEN 0 /*RECHAZOS*/
  WHEN  3 THEN 0 /*LEVES*/
  WHEN  4 THEN (53*PORINC*100*IBM*65 /datsiniestros.edad)  /*O-50*/
  WHEN  5 THEN (53*PORINC*100*IBM*65 /datsiniestros.edad)  /*O-50*/
  WHEN  6 THEN (53*PORINC*100*IBM*65 /datsiniestros.edad)  /*O-50*/
  WHEN  7 THEN (53*PORINC*100*IBM*65 /datsiniestros.edad)  /*O-50*/
  WHEN  8 THEN (53*PORINC*100*IBM*65 /datsiniestros.edad)  /*O-50*/
  WHEN  9 THEN (IBM*IPPD+8) /*5O-66*/
  WHEN 10 THEN (53*IBM*65 /datsiniestros.edad + 10) /*>66*/
  WHEN 11 THEN (53*IBM*65 /datsiniestros.edad + 10+2000*1.25*IPTD)
/*GI*/
  WHEN 12 THEN (53*IBM*65 /datsiniestros.edad + 12)  /*MUERTE*/
  END) AS 'INDEM'

FROM datsiniestros
  INNER JOIN parrentas ON
(datsiniestros.edad = parrentas.edad)
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users