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)
SELECT cmt.binid, cmt.sitename, cmt.exerciseid,
Max(cmt.datetimestamp) AS datetimestamp, max(cmt.issuancetime) AS
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
here is the sql statement from a SQL window:

FROM getLatestInBinsBetween('10-08-2003', '10-09-2003', 'Anniston',
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!
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******

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.