Reported By: Andy Grilk Reported On: 5/14/2007 For: Version 1.02 Build 1
# 2343Using a Database Name Qualifier in Sub-Queries Causes a Compilation Error I cannot use a database specifier in a where clause.
SQL.Text := 'select Inv.ID_UPCCode, Inv.ID_ID, Inv.ID_Description, ' +
'Inv.IH_Department, Inv.ID_UM, Inv.OnHand ' +
'from icrMem.ReportInventoryViewQuery as Inv ' +
'where Inv.ID_Reference not in(select Item from icrMem.ZeroItems)' +
' ' + 'order by Inv.ID_Description, Inv.ID_UPCCode';
ResolutionFixed Problem on 5/15/2007 in version 1.03 build 1
Products AffectedElevateDB Additional Software and Utilities ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial