TableName cannot be empty v6.0.2

[felixbcastillo]

Hi!
This query:
*----*
SELECT s1.*, ISNULL(Tp, d.doc_Nombre) Tipo FROM (
SELECT f.fac_Numero Numero, '' Documento, f.fac_Fecha Fecha, f.fac_Valor Debito, 0 DCap,0 DInts, 0 Credito, 0 CCAP ,0 CINT,0 Moras,0 Otros,f.fac_Concepto Concepto, null Tp, mon_Moneda, 1 Ord FROM cxc_FACTURA f WHERE f.anu_usr=0 AND f.cli_codigo='0001'
UNION ALL
SELECT d.deb_Numero ,d.deb_Documento, d.deb_Fecha, d.deb_Valor,deb_Capital, deb_Interes, 0,0,0, 0,0,d.deb_Concepto,td.tdb_Nombre,mon_Moneda,2 FROM cxc_DEBITO d LEFT OUTER JOIN cxc_TIPO_DEBITO td ON td.tdb_Prefijo=LEFT(d.deb_Numero,2) WHERE d.cli_codigo='0001'
UNION ALL
SELECT nc.ncr_Numero,nc.fac_Numero,nc.ncr_Fecha,0,ncr_Valor,0,0,0,0,0,0,nc.ncr_Concepto,null,mon_Moneda,3 FROM caj_NOTA_CREDITO nc WHERE nc.cli_Codigo='0001'
UNION ALL
SELECT p.pre_Numero, '', p.pre_Fecha, P.pre_Valor, 0, 0, 0,0,0,0,0, p.pre_Concepto,null,mon_Moneda,4 FROM cxc_PRESTAMO p WHERE p.anu_id=0 AND p.cli_codigo='0001'
UNION ALL
SELECT c.cre_Numero, '' Documento, c.cre_Fecha, 0,0,0,c.cre_Valor,c.cre_Capital,c.cre_Interes,0,0,c.cre_Concepto,tc.tcr_Nombre,mon_Moneda,5 FROM cxc_CREDITO c LEFT OUTER JOIN cxc_TIPO_CREDITO tc ON tc.tcr_Prefijo=LEFT(c.cre_Numero,2) WHERE c.ses_Anula=0 AND c.cli_codigo='0001'
UNION ALL
SELECT dbo.FillZeros(mh.mva_id),'', mh.mva_Fecha, mh.mva_DebitoCap+mh.mva_CreditoInt,0,0, mh.mva_CreditoCap+mh.mva_CreditoInt, 0,0,0,0,mh.mva_Concepto,'Mov. Cuenta de Ahorro',mon_Moneda,6 FROM cxc_CLIENTE_MOVAHORRO mh WHERE mh.cli_codigo='0001') s1
LEFT OUTER JOIN sys_DOCUMENTO d ON d.doc_Prefijo=Left(s1.Numero,2)
WHERE s1.Fecha BETWEEN current_timestamp AND current_timestamp
ORDER BY 3,14
*----*
Works perfectly in SQL Server Studio, and used to work in UNIDAC v6.0.1 and previous versions, but now in v6.0.2 and error is shown:
"TableName cannot be empty (D:\Projects\Delphi\Dac\SqlServer\Source\MSClasses.pas, line 1988)."

Any sugestions?

Thanks in advanced!

[azyk]

Thank you for the information. We have already fixed this problem. This fix will be included in the next UniDAC build.