Article View: borland.public.cppbuilder.database.ado
Article #1009Re: Problem with calculated fields
From: AlexB
Date: Wed, 01 Dec 2004 05:01
Date: Wed, 01 Dec 2004 05:01
20 lines
1863 bytes
1863 bytes
AlexB wrote: > I'll try to reproduce it in D7 today. So XPsp1,D7. 1) Insert: SQL-calculated fields are empty after insertion. 2) Edit: no new actual values in SQL-calculated fields after edition. 3) Pressing "Refresh" on navigator does (visually) nothing. > Viatcheslav V. Vassiliev wrote: >> Try use Close()/Open() or Requery() instead of refresh. 4) Requery really makes SQL-calculated fields actual but it's very expensive solution isn't it? Using such calculations is standard practice and I'm very supprised: I can't immediately see correct result of calculation in this primitive case ... How to execute SQL-calculations without such troubles? AlexB.
Technical Details
Message-ID:
<41ad5025@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!prodigy.com!newshosting.com!nx02.iad01.newshosting.com!news-peer0-test!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<41aaeb6f@newsgroups.borland.com> <41aafb52@newsgroups.borland.com> <41ab0536@newsgroups.borland.com> <41ac5fc0$1@newsgroups.borland.com> <41ac6d99@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: Wed, 01 Dec 2004 11:01:23 +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> <41ac6d99@newsgroups.borland.com> In-Reply-To: <41ac6d99@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: <41ad5025@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1101877285 212.192.185.54 (30 Nov 2004 21:01:25 -0700) Lines: 20 Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!prodigy.com!newshosting.com!nx02.iad01.newshosting.com!news-peer0-test!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail