Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BF892475D70 for ; Fri, 4 Oct 2002 17:02:08 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 5714847580B for ; Fri, 4 Oct 2002 17:02:08 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id B78203817A4; Fri, 4 Oct 2002 17:02:07 -0400 (EDT) From: "Dagoberto Torres" X-Newsgroups: comp.databases.postgresql.sql Subject: sum function Date: Fri, 4 Oct 2002 17:01:54 -0400 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: Lines: 6 X-Complaints-To: abuse@codetel.net.do X-DMCA-Notifications: http://www.giganews.com/info/dmca.html X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.1 To: pgsql-sql@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/81 X-Sequence-Number: 9799 can somebody tell me how to solve the following problem.? when I use the sum function I get an error telling me that the provider returned E_FAIL status. I'm using VB 6 with ADO 2.7 and PSQL 7.2