No announcements
Found 2145013 threads
-
0 VotesDataColumn Expression Aggregate Function with Filtering
DataColumn in the parent DataTable that uses an aggregation function like Count, but I only want to count rows in the child table that meet a certain filtering ...
-
0 Votes
Problem with Datacolumn aggregate expression
I have a master table named Orders and a detail table named Orders_detail. (Xtreme Access db) I succeeded in calculating the sum of the field [Orders_detail.Qty] by using a ... -
0 Votes
custom function for DataColumn Expression
But the second one is just a copy of col1, be aware that for an expression you need an extra datacolumn. To be honnest, I used the DataTable until Linq started and ...Unanswered | 5 Replies | 2120 Views | Created by usseer - Monday, February 26, 2018 3:13 PM | Last reply by Cor Ligthert - Monday, February 26, 2018 4:46 PM -
0 Votes
-
0 Votes
DataColumn Expression Error with LookUp
DataTable) CustomerName should be fetched into CustomerName Column of DataGrid(i mean DataTable). For this We should set DataColumn Expression for CustomerName Column of ...Answered | 5 Replies | 3001 Views | Created by dotnetsr - Thursday, May 17, 2007 2:28 PM | Last reply by dotnetsr - Tuesday, May 22, 2007 5:59 AM -
2 Votes
DataColumn Expression Evaluation
Cor, I did look at your reply. The datacolumn expression can also be used to calculate aggregate values (e.g. SUM() ). My issue was ...Answered | 10 Replies | 4194 Views | Created by Vaibhav Sawhney - Monday, May 28, 2012 6:18 AM | Last reply by Cor Ligthert - Thursday, May 31, 2012 8:55 AM -
0 Votes
DataColumn Expression
Evaluating data before data is present... like putting the carriage before the horse. You would probably have to use a seperate expression ...Answered | 1 Replies | 4531 Views | Created by happy_84k - Monday, August 20, 2007 3:55 PM | Last reply by goose007 - Monday, August 20, 2007 7:55 PM -
0 Votes
aggregate function fails when expression involves addition
I may have gotten a glimpse at the answer, not really sure. When I moved the function into the AS clause inside parens, I got a run time error saying AGGREGATE cant be ...Answered | 4 Replies | 3497 Views | Created by db042188 - Saturday, June 6, 2009 2:12 PM | Last reply by Deepak Puri - Monday, June 8, 2009 11:59 PM -
0 Votes
DataColumn Expression Error
Dear All, I have problem with DataColumn. Expression An unhandled exception of type ...Answered | 2 Replies | 5508 Views | Created by dotnetsr - Thursday, May 10, 2007 3:42 PM | Last reply by dotnetsr - Sunday, May 13, 2007 2:32 PM -
2 Votes
Cannot have aggregate function in expression
try to sum the count I get an error which says "Cannot have aggregate function in expression". What I attempted to ...Answered | 17 Replies | 6898 Views | Created by nlkindle - Friday, October 5, 2012 4:03 PM | Last reply by nlkindle - Tuesday, October 16, 2012 4:46 PM -
0 Votes
DataColumn Expression Between
Actually the ADO.NET DataColumn Expression article does mention the "Between" but gives no examples. There are several forum posts and a stackoverflow that says Between is ...Answered | 3 Replies | 4351 Views | Created by Raamakarthikeyan - Thursday, September 20, 2012 9:26 AM | Last reply by Jordan B - Friday, November 2, 2012 5:53 PM -
1 Votes
Cannot have aggregate function in expression error
came up because Access does not allow to nest SQL aggregate functions. Using a domain aggregate function (DAvg) might work (will not cause an error) but will give you ...Answered | 13 Replies | 15332 Views | Created by Zoe.Ohara - Monday, December 13, 2010 12:31 PM | Last reply by Zoe.Ohara - Tuesday, December 14, 2010 11:20 AM -
0 Votes
Problems with Aggregate(expression, scope)
Hello! I’m having a problem with the Aggregate() function, maybe someone here can help me ... I have created a quite simple ...Answered | 2 Replies | 4110 Views | Created by Julien Montserrat - Friday, August 29, 2008 1:01 PM | Last reply by Julien Montserrat - Monday, September 1, 2008 7:55 AM -
0 Votes
Cannot have aggregate function in expression error
And use WHERE, HAVING use for filter aggregate function: SELECT [2014 cer master list].[approved/closed] ,[2014 cer ...Answered | 2 Replies | 530 Views | Created by Staserabella - Wednesday, December 10, 2014 11:04 PM | Last reply by Dziubek Michał - Thursday, December 11, 2014 8:16 AM -
0 Votes
edit datacolumn with expression, in datagridview
I have a datatable with some columns calculated by expression, say "IIF(column1 = 'Maybe 1', '1', '2')". But in rare cases theAnswered | 1 Replies | 2739 Views | Created by visual ryan - Wednesday, April 2, 2008 6:54 PM | Last reply by AlexBB - Vista Ult64 SqlSer64 WinSer64 - Wednesday, April 2, 2008 9:29 PM -
0 Votes
CTE performance with aggregate function
Hi, I'm just double checking. I'm using a CTE with an Aggregate function. First it was very slow. When I moved the where clause from the outer select into the CTE it got ...Answered | 5 Replies | 1350 Views | Created by ChristophV - Tuesday, November 15, 2016 8:56 AM | Last reply by ChristophV - Tuesday, November 15, 2016 2:14 PM -
0 Votes
Cannot perform an aggregate function on an expression,sql,query,aggregate,function,subquery
) AS [Code1] SUM(Case WHEN ID is null then COUNT(1) ELSE o END ) as ID_Count from Incident Error: Cannot ...Answered | 6 Replies | 2493 Views | Created by SQL_Gun - Saturday, October 6, 2012 12:39 AM | Last reply by RichardTheKiwi - Saturday, October 6, 2012 5:17 AM -
0 Votes
Aggregate function
; Column 'PRODUCTION_TABLE.ProcessDate' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY ...Answered | 8 Replies | 2029 Views | Created by Astanto - Wednesday, June 13, 2012 7:30 AM | Last reply by Astanto - Wednesday, June 13, 2012 8:47 AM -
0 Votes
Parameter in aggregate function
Hi, I'm having this little weird problem with Visual Studio. It doesn't seem to accept the param in the aggregate function:Unanswered | 2 Replies | 3130 Views | Created by zoffdino - Tuesday, November 21, 2006 4:13 AM | Last reply by VMazur - Tuesday, November 21, 2006 11:26 AM -
0 Votes
aggregate function problem
doesn't include the specified expression '[AHI (e/hr)]' as part of an aggregate function". Thanks for your ...Answered | 8 Replies | 810 Views | Created by Kenrav - Saturday, April 6, 2013 2:53 PM | Last reply by Kenrav - Saturday, April 6, 2013 5:40 PM - Items 1 to 20 of 2145013 Next ›
No announcements
