View Incident Report

Serious

Reported By: Hüseyin Aliz
Reported On: 10/6/2002
For: Version 3.17 Build 1

# 1239 Using an SQL Parameter in a Binary UPDATE SET Expression Results in Incorrect Update of Records

When i run following query in dbsys it works fine. But the same query in my program does set kampagnepris to 0 which is not what it should do.

DBSYS
-----

update "varer.dat"
set kampagnepris = (pris - (pris / 100 * 10))
where pris > 0;

Application
-----------

update "varer.dat"
set kampagnepris = (pris - (pris / 100 * :procenttal))
where pris > 0;

:procenttal is defined as ftfloat.

Resolution

Fixed Problem on 10/8/2002 in version 3.18 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap