Reported By: Arnd Baranowski Reported On: 10/12/2004 For: Version 4.12 Build 1
# 1867SQL INSERT Statements with Aggregated Sub-Queries Cause a Type Mismatch Error Your parser does not permit the following SQL. It does not recognize Count(CarrierCode) as Integer value.
Insert into RC_Analyse_M
(Carrierid, Datum, Carrier, Destination,CodesAnzahl)
Select
Carrierid, Gueltigab, Carrier, Destination,Count(CarrierCode)
from
RC_Analyse
WHERE Carrierid = 86
Group by Destination, Gueltigab
Order by Destination, Gueltigab
ResolutionFixed Problem on 10/13/2004 in version 4.13 build 1