Re: [sqlite] using sqlite calculated field
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
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
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