Infralution Support Forum Index Infralution Support
Support groups for Infralution products
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to execute an aggregate function from within VDO

 
Post new topic   Reply to topic    Infralution Support Forum Index -> Virtual Data Objects Support
View previous topic :: View next topic  
Author Message
MikeR



Joined: 25 Jun 2016
Posts: 17

PostPosted: Fri May 04, 2018 4:03 pm    Post subject: How to execute an aggregate function from within VDO Reply with quote

I want to do something like this:

select max(my_primary_key_column) from myTable;

If possible, how can this be implemented in VDO and the value extracted from the VDO classes?

Thanks.
_________________
Thanks,

-- Mike R.
Back to top
View user's profile Send private message
Infralution



Joined: 28 Feb 2005
Posts: 4838

PostPosted: Fri May 04, 2018 11:12 pm    Post subject: Reply with quote

VDO is designed to return the results of database select queries as an IList interface and to virtualize this (so that the records are not loaded until accessed). So it probably doesn't make sense to try to do that sort of query through VDO. I would recommend that you just use normal ADODB commands to execute this query.
_________________
Infralution Support
Back to top
View user's profile Send private message Visit poster's website
MikeR



Joined: 25 Jun 2016
Posts: 17

PostPosted: Sat May 05, 2018 12:51 am    Post subject: Reply with quote

Thanks, I suspected that might be the case. I just used Npgsql package to do it most simply, and it worked cleanly. (ExecuteScalar).
_________________
Thanks,

-- Mike R.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Infralution Support Forum Index -> Virtual Data Objects Support All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group