Re: Problem with calculated fields

Article View: borland.public.cppbuilder.database.ado

Article #1006

Back to borland.public.cppbuilder.database.ado Previous Next

#1006

From: AlexB
Date: Tue, 30 Nov 2004 12:54

15 lines
1605 bytes

Viatcheslav V. Vassiliev wrote:

> Try use Close()/Open() or Requery() instead of refresh.

Field/grid column FaceArea shows illegal data immediately after 
insertion, it's "internal" problem.

Today I've switched to calculated fields (calculations in OnCalcField 
event, no calc-s in SQL), they works correctly.

It's workaround of course. Why SQL gives bad result?........

I'll try to reproduce it in D7 today.

AlexB.

Technical Details

Message-ID: <41ac6d99@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!prodigy.com!atl-c02.usenetserver.com!c03.atl99.usenetserver.com!news.usenetserver.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References:

<41aaeb6f@newsgroups.borland.com> <41aafb52@newsgroups.borland.com> <41ab0536@newsgroups.borland.com> <41ac5fc0$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,14f1cefa54e637b5
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Tue, 30 Nov 2004 18:54:42 +0600
From: AlexB <b.a.v@inbox.ru>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: ru, en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Problem with calculated fields
References: <41aaeb6f@newsgroups.borland.com> <41aafb52@newsgroups.borland.com> <41ab0536@newsgroups.borland.com> <41ac5fc0$1@newsgroups.borland.com>
In-Reply-To: <41ac5fc0$1@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 212.192.185.54
Message-ID: <41ac6d99@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1101819289 212.192.185.54 (30 Nov 2004 04:54:49 -0700)
Lines: 15
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!prodigy.com!atl-c02.usenetserver.com!c03.atl99.usenetserver.com!news.usenetserver.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message