search
Twitter Rss Feeds
MicrosoftArticlesForumsGroups
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml/Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

Web ProgrammingArticlesForumsGroups
JavaScript
ASP
ASP.NET
Web Services

Non-MicrosoftArticlesForumsGroups
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

DatabasesArticlesForumsGroups
SQL Server
Access
Oracle
MySQL
Other Databases

OfficeArticlesForumsGroups
Microsoft Excel
Microsoft Word
Microsoft Powerpoint
Publisher
Money

Operating SystemsArticlesForumsGroups
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsGroups
Share Point
BizTalk
Site Server
Exhange Server
IIS
Transaction Server

Graphic DesignArticlesForumsGroups
Macromedia Flash
Adobe PhotoShop
Microsoft Expression

OtherArticlesForumsGroups
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Reviews
Search Engines
Resumes

 

Previous Thread:   dotnet query

9/14/2005 6:25:25 AM    AGGREGATE function don't update
Hi all.  
  
I 'm playing with parent/child relationship columns and I've tried  
  
AGGREGATE functions.  
  
My test is simple:  
  
I've created a table "C" with 2 columns:  
  
"Price" and "P_ID"  
  
and a table "P" with 2 columns  
  
"P_ID" as primary key and  
  
"SumPrice" to contain computed values.  
  
I've created a relationship  
  
PCol = ds.Tables["P"].Columns["P_ID"];  
  
CCol = ds.Tables["C"].Columns["P_ID"];  
  
rel = new DataRelation("P_C_rel",PCol, CCol);  
  
and added to the dataset.  
  
Then I've specified an expression for the column SumPrice  
  
SumPriceCol.Expression = "Sum(Child.Price)";  
  
It works fine if I change only table "C" "Price" elements but it  
  
doesn't work if I change table "C" "P_ID" elements.  
  
It seem like it doesn't refresh value immediately  when i change row,  
  
but it processes changes one step later.  
  
In fact if I change again "P_ID" values, computed column displays a  
  
value that was correct with the previous input.  
  
Surely I'm missing something.  
  
Can someone help, please?  
  
Thanks.  
  
Maurizio.

9/16/2005 5:07:05 PM    Re: AGGREGATE function don't update
V1.1 had issues with updating values based on expressions when relationships  
  
are involved.  
  
If/when you can try V2.0 all those issues should be corrected.  
  
--  
  
This posting is provided "AS IS", with no warranties, and confers no rights.  
  
Please do not send email directly to this alias. This alias is for newsgroup  
  
purposes only.  
  
"mr.mau" <mr.mau@tiscali.it> wrote in message  
  
news:1126704325.248172.225590@g44g2000cwa.googlegroups.com...


Pete's Blog   |    Pete's Resume   |    Robbe's Blog   |    Robbe's Resume   |    Archive #2   |    Archive #3   |    Dotnetslackers   |    XmlPitStop   |    Advertise   |   Contact Us   |   Privacy   |   Copyright (c) 2000 - 2009 eggheadcafe.com  All rights reserved.