table name can't be empty.(MS SQL server)

[xalion]

hi
when update unidac 6.0,my application can't work.
my sql is

Code: Select all

select DJ_ANIMAL.FID, DJ_ANIMAL.FBillCode, DJ_ANIMAL.FBillName, DJ_ANIMAL.FDATE,  DJ_ANIMAL.FCUSTOMERNAME, DJ_ANIMAL.FGOODSNAME, DJ_ANIMAL.FUNIT, DJ_ANIMAL.FQUANTITY,  DJ_ANIMAL.FSHENG, DJ_ANIMAL.FSHI, DJ_ANIMAL.FXIAN, DJ_ANIMAL.FXIANG,  DJ_ANIMAL.FDSHENG, DJ_ANIMAL.FDSHI, DJ_ANIMAL.FDXIAN, DJ_ANIMAL.FDXIANG,  DJ_ANIMAL.FYZGJPH, DJ_Animal.FCorpName, DJ_Animal.FCheckUnit, DJ_Animal.FCUSTOMERPHONE, dj_Animal.FQuarantSN  from (select DJ_ANIMAL.FID, FDATE, FCUSTOMERNAME, FGOODSNAME, FUNIT, FQUANTITY, FSHENG, FSHI, FXIAN, FXIANG,  FDSHENG, FDSHI, FDXIAN, FDXIANG, FYZGJPH, FDSHITREECODE, FDXIANTREECODE, FDXIANGTREECODE,  FCorpName, '' FCheckUnit, FCUSTOMERPHONE, FQuarantSN, BillDef.FCode FBillCode, BILLDEF.FNAME FBillName from DJ_ANIMAL  inner join BILLDEF on DJ_ANIMAL.FBillCode=billDef.Fcode  where FDATE between '2015-1-18' and '2015-1-19' and DJ_ANIMAL.FState <> 0 and FINVALID = 0 and (FBillCode = '600' or FBillCode = '800')  Union  select CR_RECORDITEM.FROWID FID, CR_RECORD.FDATE, CR_RECORDITEM.FCUSTOMERNAME, CR_RECORDITEM.FGOODSNAME, CR_RECORDITEM.FUNIT, 	CR_RECORDITEM.FQUANTITY, CR_RECORD.FSHENG, CR_RECORD.FSHI, CR_RECORD.FXIAN, CR_RECORD.FXIANG, 	CR_RECORDITEM.FDSHENG, CR_RECORDITEM.FDSHI, CR_RECORDITEM.FDXIAN, CR_RECORDITEM.FDXIANG, 	CR_RECORD.FYZGJPH, CR_RECORDITEM.FDSHITREECODE, CR_RECORDITEM.FDXIANTREECODE, CR_RECORDITEM.FDXIANGTREECODE,  CR_RECORD.FUNITNAME FCORPNAME,	CR_RECORD.FCorpName FCheckUnit, CR_RECORDITEM.FCUSTOMERPHONE, CR_RECORDITEM.FQuarantSN,   CR_RECORD.FTYPECODE FBillCode, FTYPENAME FBillName 	from CR_RECORD inner join CR_RECORDITEM on CR_RECORD.FID = CR_RECORDITEM.FID  where CR_RECORD.FDATE between '2015-1-18' and '2015-1-19' and FState <> 0  ) DJ_ANIMAL  inner join (select * from DJ_PushMessageRelation where FDEFAULTRELATIONID = '0001/0113') DJ_PushMessageRelation  on DJ_ANIMAL.FDSHENG = DJ_PushMessageRelation.FSHENG  and DJ_ANIMAL.FDSHITREECODE = DJ_PushMessageRelation.FSHITREECODE and DJ_ANIMAL.FDXIANTREECODE = DJ_PushMessageRelation.FXIANTREECODE  and DJ_ANIMAL.FDXIANGTREECODE = DJ_PushMessageRelation.FXIANGTREECODE   where (select count(*) from dj_IsReadPushMessage where  dj_IsReadPushMessage.FID = DJ_Animal.FID  and FRelationID = '0001/0113/0114/4933') = 0  

when open the query
it shows error: table name cannot be empty.


by the way. unidac 5.0 works fine.

[azyk]

Thank you for the information. We have reproduced this problem. We will investigate this behavior and inform you about the results.

[azyk]

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

[xalion]

thank you, when will you release next build?

[azyk]

The next UniDAC build is expected in the next month.