Icon View Incident Report

Serious Serious
Reported By: Andy Grilk
Reported On: 5/14/2007
For: Version 1.02 Build 1
# 2343 Using 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';



Resolution Resolution
Fixed Problem on 5/15/2007 in version 1.03 build 1


Products Affected Products Affected
ElevateDB 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

Image