Search Postgresql Archives

odbc and psql 8.1.0

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi , has anybody experienced any problem with the odbc driver that comes with postgres 8.1.0 , I was testing my application against the beta 4 and everything was working OK, now I installed the 8.1.0 plus the odbc driver , and now my application is returning wrong results , the application is the same, no one modification was done, if I run my query from withing the interactive sql editor of pgAdmin, the query returns what it is supposed to return,  the same query from my application doesnt work ( I tested the query in PowerBulder 8 and VASmalltalk 7 both with same wrong result).

I would appreciate any hint on this

thanks in advance

Hugo

below is the query, this query should return rows with D's  and P's , but it returns only rows with D's, the problem is that if I count the rows I realize that it returns all the rows it should (642), but it returns all of them with D's,  if I run the same query from pgAdmin it returns all the rows(642) but with the correct values , 412 P's and  230 D's

*****
select distinct 'D' as estado ,  zona, ano, campana , contrato
  from comisiones.avon as avon
  where zona = :zona and ano = :ano and campana = :campana
        and tipo in ('50')
        and subtipo in ('02' , '03')
  group by zona,  ano, campana , contrato

  union

  select distinct  'D' as estado , zona, ano, campana , contrato
  from comisiones.viru as viru
  where zona = :zona and ano = :ano and campana = :campana
        and tipo in ('50')
        and subtipo in ('02' , '03')   
  group by zona,  ano, campana , contrato


union

select distinct 'P' as estado, zona, ano, campana , contrato
  from comisiones.avon as avon
  where zona = :zona and ano = :ano and campana = :campana
        and tipo in ('10', '20')
        and subtipo in ('01')
        and contrato not in ( 
                    select distinct contrato
                    from comisiones.viru as viru
                    where zona = :zona and ano = :ano and campana = :campana
                            and tipo in ('10', '20')
                            and subtipo in ('01')
       
                    )
  group by zona,  ano, campana , contrato

  union

  select distinct  'P' as estado, zona, ano, campana , contrato
  from comisiones.viru as viru
  where zona = :zona and ano = :ano and campana = :campana
        and tipo in ('10', '20')
        and subtipo in ('01')
        and contrato not in ( 
                    select distinct contrato
                    from comisiones.avon as avon
                    where zona = :zona and ano = :ano and campana = :campana
                            and tipo in ('10', '20')
                            and subtipo in ('01')       
                    )
       
  group by zona,  ano, campana , contrato

union
  SELECT DISTINCT 'P' as estado, avon.zona as zona, avon.ano as ano , avon.campana as campana , avon.contrato 
    FROM comisiones.avon as avon,  
         comisiones.viru  as viru
   WHERE ( avon.zona = viru.zona ) and 
         ( avon.contrato = viru.contrato ) and 
         ( avon.ano = viru.ano ) and 
         ( avon.campana = viru.campana )    and
            avon.zona = :zona and avon.ano = :ano and avon.campana = :campana
            and ( ( avon.tipo in ('10', '20')
                            and avon.subtipo in ('01') )
                    and ( viru.tipo in ('10', '20')
                            and viru.subtipo in ('01') ))

*****

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux