We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Expression column. Can't use aggregate function.

Thread ID:

Created:

Updated:

Platform:

Replies:

4968 Jun 11,2003 05:03 AM Feb 26,2004 08:40 AM Windows Forms 3
loading
Tags: FAQ
Vilius
Asked On June 11, 2003 05:03 AM

Hi, When I tryed to create expresion column using some relation navigation ( Child keyword ) , the following exception was thrown : An unhandled exception of type 'System.Data.EvaluateException' occurred in system.data.dll Additional information: Unbound reference in the aggregate expression 'Sum(child.[Cost])'. Could someone suggest how to use expresion columns correctly ?

sore_ron
Replied On July 2, 2003 05:33 AM

Did you find an answer to this problem ?. I have a similar problem when trying to use the max function. > Hi, > > When I tryed to create expresion column using some relation navigation ( Child keyword ) , the following exception was thrown : > > An unhandled exception of type 'System.Data.EvaluateException' occurred in system.data.dll > > Additional information: Unbound reference in the aggregate expression 'Sum(child.[Cost])'. > > Could someone suggest how to use expresion columns correctly ?

Tim Lloyd
Replied On July 28, 2003 04:30 PM

As far as I can see, you have to add the column 'after' you have filled your dataset. If you try to add it before there is any data, it doesn't like it. Like many things in ADO.NET, it doesn't act nicely, or give you an error message that would give a good clue as to what's going on when it pukes... Tim. > > Hi, > > When I tryed to create expresion column using some relation navigation ( Child keyword ) , the following exception was thrown : > > An unhandled exception of type 'System.Data.EvaluateException' occurred in system.data.dll > > Additional information: Unbound reference in the aggregate expression 'Sum(child.[Cost])'. > > Could someone suggest how to use expresion columns correctly ?

Administrator [Syncfusion]
Replied On February 26, 2004 08:40 AM

This worked for me. Thanks. It would be nice to know why it fails. > As far as I can see, you have to add the column 'after' you have filled your dataset. If you try to add it before there is any data, it doesn't like it. > > Like many things in ADO.NET, it doesn't act nicely, or give you an error message that would give a good clue as to what's going on when it pukes... > > Tim. > > > > Hi, > > > > When I tryed to create expresion column using some relation navigation ( Child keyword ) , the following exception was thrown : > > > > An unhandled exception of type 'System.Data.EvaluateException' occurred in system.data.dll > > > > Additional information: Unbound reference in the aggregate expression 'Sum(child.[Cost])'. > > > > Could someone suggest how to use expresion columns correctly ? >

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;