Returned Result via ODBC!

From: Nuchanach Klinjun <nuchk(at)inet(dot)co(dot)th>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Returned Result via ODBC!
Date: 1999-09-21 06:49:28
Message-ID: Pine.OSF.4.10.9909211223270.13034-100000@johann.inet.co.th
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Dear Sir,

I've problem with getting output from database via ODBC
my query is -->
select s.account,sum(dround(date_part('epoch',s.stop-s.start)/36.0)/100) as
usage,sum(date_part('epoch',s.stop-s.start)/3600*s.rate/t.rate) as charge
from session s,ticket t
where s.stop >= '1999/06/10' and s.stop < '1999/06/21' and
s.ticket = t.id and not t.free and s.nas = '203.151.66.7' group by
s.account;
I use MS Access 97 as frontend application and postodbc
6.4.7 and I sent the passthrough query to the postgres backend. it always
return only the first field and the second (first sum field). and I noticed
that the backend always return only some other fields and only 1 sum field
(it's wierd).
with the same query I tried run it on the database promt it return
the complete result.

Please help.

Regards,

-----------------------------------------
Nuchanach Klinjun
R&D Project. Internet Thailand
Email: nuchk(at)inet(dot)co(dot)th

Browse pgsql-interfaces by date

  From Date Subject
Next Message Antonio Pires 1999-09-21 11:51:11 pg_database
Previous Message Constantin Teodorescu 1999-09-21 05:19:26 Re: [INTERFACES] pgaccess Q