By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,970 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

Execute Function from VB/ADO

P: n/a
Here is my function:

CREATE OR REPLACE FUNCTION public.getLatestInBinsBetween(timestamp,
timestamp, varchar, varchar)
RETURNS SETOF record AS
'
SELECT cmt.binid, cmt.sitename, cmt.exerciseid,
Max(cmt.datetimestamp) AS datetimestamp, max(cmt.issuancetime) AS
IssuanceTime
FROM consolidatedMetReading cmt INNER JOIN (SELECT Distinct BinID,
SiteName, ExerciseID
FROM consolidatedMetReading gbib
WHERE gbib.BinID BETWEEN $1 and $2
AND gbib.SiteName = $3
AND gbib.ExerciseID = $4) gbib
ON gbib.BinID = cmt.BinID
AND gbib.SiteName = cmt.SiteName
AND gbib.ExerciseID = cmt.ExerciseID
GROUP BY cmt.binid, cmt.sitename, cmt.exerciseid
ORDER BY cmt.binid, cmt.sitename, cmt.exerciseid
'
LANGUAGE 'sql' VOLATILE;
here is the sql statement from a SQL window:

SELECT *
FROM getLatestInBinsBetween('10-08-2003', '10-09-2003', 'Anniston',
'real')
AS gLIBB(binid timestamp, sitename varchar, exerciseid varchar,
datetimestamp timestamp, issuancetime timestamp)
How can I execute this from a ADO connection?

Thomas LeBlanc

__________________________________________________ _______________
Fast, faster, fastest: Upgrade to Cable or DSL today!
https://broadband.msn.com
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.