Returned Result via ODBC!
От | Nuchanach Klinjun |
---|---|
Тема | Returned Result via ODBC! |
Дата | |
Msg-id | Pine.OSF.4.10.9909211223270.13034-100000@johann.inet.co.th обсуждение исходный текст |
Список | 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@inet.co.th
В списке pgsql-interfaces по дате отправления: