View previous topic :: View next topic |
Author |
Message |
MikeR
Joined: 25 Jun 2016 Posts: 29
|
Posted: Fri May 04, 2018 4:03 pm Post subject: How to execute an aggregate function from within VDO |
|
|
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 |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Fri May 04, 2018 11:12 pm Post subject: |
|
|
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 |
|
|
MikeR
Joined: 25 Jun 2016 Posts: 29
|
Posted: Sat May 05, 2018 12:51 am Post subject: |
|
|
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 |
|
|
|