Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.04 » View Incident Report |
Minor |
Reported By: Tiago Ameller Reported On: 9/28/2010 For: Version 2.04 Build 3 |
SCRIPT () BEGIN EXECUTE IMMEDIATE 'CREATE TEMPORARY TABLE FHH AS SELECT DISTINCT M.CODIGO, FECHAHORA FROM YCEVENTO INNER JOIN YCVENDET D ON D.EVENTOINI = CODIGO INNER JOIN YCVENMAS M ON M.CODIGO = D.VENTA WHERE FECHAHORA < DATE ''2010-04-05'' WITH DATA'; EXECUTE IMMEDIATE 'UPDATE YCVENMAS M SET FECHAHORAVENTA = SELECT IFNULL(FECHAHORA,M.FECHAHORAVENTA,FECHAHORA) FROM FHH WHERE FHH.CODIGO = M.CODIGO'; END Workaround: SCRIPT () BEGIN BEGIN EXECUTE IMMEDIATE 'DROP TABLE FHH'; EXCEPTION END; EXECUTE IMMEDIATE 'CREATE TEMPORARY TABLE FHH AS SELECT DISTINCT M.CODIGO, FECHAHORA FROM YCEVENTO INNER JOIN YCVENDET D ON D.EVENTOINI = CODIGO INNER JOIN YCVENMAS M ON M.CODIGO = D.VENTA WHERE FECHAHORA < DATE ''2010-04-05'' WITH DATA'; EXECUTE IMMEDIATE 'UPDATE YCVENMAS M SET FECHAHORAVENTA = IFNULL(SELECT FECHAHORA FROM FHH WHERE FHH.CODIGO = M.CODIGO,M.FECHAHORAVENTA,SELECT FECHAHORA FROM FHH WHERE FHH.CODIGO = M.CODIGO)'; END
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |