View Incident Report

Serious

Reported By: Robert Parrish
Reported On: 9/9/2002
For: Version 3.12 Build 1

# 1207 SQL Query Containing AVG Function Not Working Properly When Parameters Are Used

The query below worked with 3.08 but with 3.12 it adds the values together rather then taking the average. If I run the query in dbsys without the parameter the average function works properly.

FSLPQ.Close;
FSLPQ.ParamCheck:=True;
FSLPQ.Params[0].AsInteger := DmReh.tblPropertyPropertyNo.AsInteger;
FSLPQ.Prepare;
FSLPQ.Open;
FSLPQ2.Close;

---Sql---
SELECT Avg(ListPrice)
FROM ForSale
Where ForSale.PropertyNo = :PropNo

Resolution

Fixed Problem on 9/10/2002 in version 3.17 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap