DataWindow Select

I have a problem. I have a datawindow that returns around 14000 rows. My
connections is with Oracle. This DW in diferent executions returns diferents
number of rows and never chage are done in database. Why can be this????

Thanks.

Datawindow select is:

SELECT expediente.expediente_id,
  sf_importe_preview (expediente.importe_pendiente,
expediente.codigo_moneda_pendiente_id) importe_pendiente,
  sf_formato_moneda_defecto (expediente.importe_pendiente,
expediente.codigo_moneda_pendiente_id) importe_pendiente_st,
  expediente.aportador_id,
  expediente.numero_expediente,
  expediente.numero_expediente_externo,
  expediente.descripcion,
  carpeta.fecha_limite_gestion,
  TO_DATE (TO_CHAR (carpeta.fecha_alta, 'dd/mm/yyyy')) fecha_alta,
  carpeta.programada,
  carpeta.fecha_programada,
  carpeta.carpeta_id,
      carpeta.fecha_ultima_gestion,
      carpeta.alarma,
  carpeta.prioridad,
  carpeta.gestor_busquedas_id,
  sf_nemo_from_id (carpeta.codigo_gestion_id) codigo,
  sf_nemo_from_id (carpeta.subcodigo_gestion_id) subcodigo,
  DECODE (TO_CHAR (fecha_ultima_gestion, 'dd/mon/yyyy'), TO_CHAR (SYSDATE,
'dd/mon/yyyy'), 1, 0) tocado,
  DECODE (gestor_busquedas_id, 0, 0, 1) enviado_busquedas,
  sf_nombre_deudor (expediente.deudor_id) nombre_persona,
  sf_numero_dni_deudor (expediente.deudor_id) numero_dni,
  aportador.nombre_comercial
FROM carpeta, expediente, aportador
WHERE ((carpeta.gestor_asignado_id = 84)) AND (expediente.carpeta_id =
carpeta.carpeta_id)
  AND (expediente.aportador_id = aportador.aportador_id)
  AND (expediente.devuelto = 0) AND (carpeta.visible = 1)
 ORDER BY DECODE (carpeta.programada, 1, DECODE (SIGN
(carpeta.fecha_programada - SYSDATE), -1, carpeta.fecha_programada -
SYSDATE, 2), 1) ASC, carpeta.orden_tratamiento ASC, DECODE
(sf_codigo_from_id (carpeta.codigo_gestion_id), '01', DECODE
(sf_codigo_from_id (carpeta.subcodigo_gestion_id), '17', 13, '05', 11, '03',
14, '02', 10, '01', 9,  999), '02', DECODE (sf_codigo_from_id
(carpeta.subcodigo_gestion_id), '16', 12, '15', 15,  999), '15', 8, '16',
DECODE (sf_codigo_from_id (carpeta.subcodigo_gestion_id), '24', 5, '23', 4,
'22', 3, '21', 2, '20', 7, '19', 6, '18', 1,  999),  999) ASC, TRUNC
(carpeta.fecha_ultima_gestion) ASC,
sf_importe_codigo(expediente.importe_pendiente,expediente.codigo_moneda_pend
iente_id,0) DESC, carpeta.alarma DESC



0
M
4/3/2001 11:29:09 AM
sybase.powerbuilder.general 62418 articles. 18 followers. Follow

3 Replies
594 Views

Similar Articles

[PageSpeed] 51

Could anyone help me, please???
Thanks.
  Mamen.



"M.Carmen" <mamen@sicsa.net> escribi� en el mensaje
news:ORU5zTDvAHA.260@forums.sybase.com...
> I have a problem. I have a datawindow that returns around 14000 rows. My
> connections is with Oracle. This DW in diferent executions returns
diferents
> number of rows and never chage are done in database. Why can be this????
>
> Thanks.
>
> Datawindow select is:
>
> SELECT expediente.expediente_id,
>   sf_importe_preview (expediente.importe_pendiente,
> expediente.codigo_moneda_pendiente_id) importe_pendiente,
>   sf_formato_moneda_defecto (expediente.importe_pendiente,
> expediente.codigo_moneda_pendiente_id) importe_pendiente_st,
>   expediente.aportador_id,
>   expediente.numero_expediente,
>   expediente.numero_expediente_externo,
>   expediente.descripcion,
>   carpeta.fecha_limite_gestion,
>   TO_DATE (TO_CHAR (carpeta.fecha_alta, 'dd/mm/yyyy')) fecha_alta,
>   carpeta.programada,
>   carpeta.fecha_programada,
>   carpeta.carpeta_id,
>       carpeta.fecha_ultima_gestion,
>       carpeta.alarma,
>   carpeta.prioridad,
>   carpeta.gestor_busquedas_id,
>   sf_nemo_from_id (carpeta.codigo_gestion_id) codigo,
>   sf_nemo_from_id (carpeta.subcodigo_gestion_id) subcodigo,
>   DECODE (TO_CHAR (fecha_ultima_gestion, 'dd/mon/yyyy'), TO_CHAR (SYSDATE,
> 'dd/mon/yyyy'), 1, 0) tocado,
>   DECODE (gestor_busquedas_id, 0, 0, 1) enviado_busquedas,
>   sf_nombre_deudor (expediente.deudor_id) nombre_persona,
>   sf_numero_dni_deudor (expediente.deudor_id) numero_dni,
>   aportador.nombre_comercial
> FROM carpeta, expediente, aportador
> WHERE ((carpeta.gestor_asignado_id = 84)) AND (expediente.carpeta_id =
> carpeta.carpeta_id)
>   AND (expediente.aportador_id = aportador.aportador_id)
>   AND (expediente.devuelto = 0) AND (carpeta.visible = 1)
>  ORDER BY DECODE (carpeta.programada, 1, DECODE (SIGN
> (carpeta.fecha_programada - SYSDATE), -1, carpeta.fecha_programada -
> SYSDATE, 2), 1) ASC, carpeta.orden_tratamiento ASC, DECODE
> (sf_codigo_from_id (carpeta.codigo_gestion_id), '01', DECODE
> (sf_codigo_from_id (carpeta.subcodigo_gestion_id), '17', 13, '05', 11,
'03',
> 14, '02', 10, '01', 9,  999), '02', DECODE (sf_codigo_from_id
> (carpeta.subcodigo_gestion_id), '16', 12, '15', 15,  999), '15', 8, '16',
> DECODE (sf_codigo_from_id (carpeta.subcodigo_gestion_id), '24', 5, '23',
4,
> '22', 3, '21', 2, '20', 7, '19', 6, '18', 1,  999),  999) ASC, TRUNC
> (carpeta.fecha_ultima_gestion) ASC,
>
sf_importe_codigo(expediente.importe_pendiente,expediente.codigo_moneda_pend
> iente_id,0) DESC, carpeta.alarma DESC
>
>
>


0
forums
4/16/2001 12:59:37 PM
Most likely because you are hitting nulls somewhere.

--
Terry Dykstra (TeamSybase)
Please state PB / OS / DB versions in your post.
MySybase http://my.sybase.com/mysybase
Search Deja: http://www.pfcguide.com/_newsgroups/search.asp

"forums.sybase.com" <mamen@sicsa.net> wrote in message
news:G#lkqgnxAHA.191@forums.sybase.com...
> Could anyone help me, please???
> Thanks.
>   Mamen.
>
>
>
> "M.Carmen" <mamen@sicsa.net> escribi� en el mensaje
> news:ORU5zTDvAHA.260@forums.sybase.com...
> > I have a problem. I have a datawindow that returns around 14000 rows. My
> > connections is with Oracle. This DW in diferent executions returns
> diferents
> > number of rows and never chage are done in database. Why can be this????
> >
> > Thanks.
> >
> > Datawindow select is:
> >
> > SELECT expediente.expediente_id,
> >   sf_importe_preview (expediente.importe_pendiente,
> > expediente.codigo_moneda_pendiente_id) importe_pendiente,
> >   sf_formato_moneda_defecto (expediente.importe_pendiente,
> > expediente.codigo_moneda_pendiente_id) importe_pendiente_st,
> >   expediente.aportador_id,
> >   expediente.numero_expediente,
> >   expediente.numero_expediente_externo,
> >   expediente.descripcion,
> >   carpeta.fecha_limite_gestion,
> >   TO_DATE (TO_CHAR (carpeta.fecha_alta, 'dd/mm/yyyy')) fecha_alta,
> >   carpeta.programada,
> >   carpeta.fecha_programada,
> >   carpeta.carpeta_id,
> >       carpeta.fecha_ultima_gestion,
> >       carpeta.alarma,
> >   carpeta.prioridad,
> >   carpeta.gestor_busquedas_id,
> >   sf_nemo_from_id (carpeta.codigo_gestion_id) codigo,
> >   sf_nemo_from_id (carpeta.subcodigo_gestion_id) subcodigo,
> >   DECODE (TO_CHAR (fecha_ultima_gestion, 'dd/mon/yyyy'), TO_CHAR
(SYSDATE,
> > 'dd/mon/yyyy'), 1, 0) tocado,
> >   DECODE (gestor_busquedas_id, 0, 0, 1) enviado_busquedas,
> >   sf_nombre_deudor (expediente.deudor_id) nombre_persona,
> >   sf_numero_dni_deudor (expediente.deudor_id) numero_dni,
> >   aportador.nombre_comercial
> > FROM carpeta, expediente, aportador
> > WHERE ((carpeta.gestor_asignado_id = 84)) AND (expediente.carpeta_id =
> > carpeta.carpeta_id)
> >   AND (expediente.aportador_id = aportador.aportador_id)
> >   AND (expediente.devuelto = 0) AND (carpeta.visible = 1)
> >  ORDER BY DECODE (carpeta.programada, 1, DECODE (SIGN
> > (carpeta.fecha_programada - SYSDATE), -1, carpeta.fecha_programada -
> > SYSDATE, 2), 1) ASC, carpeta.orden_tratamiento ASC, DECODE
> > (sf_codigo_from_id (carpeta.codigo_gestion_id), '01', DECODE
> > (sf_codigo_from_id (carpeta.subcodigo_gestion_id), '17', 13, '05', 11,
> '03',
> > 14, '02', 10, '01', 9,  999), '02', DECODE (sf_codigo_from_id
> > (carpeta.subcodigo_gestion_id), '16', 12, '15', 15,  999), '15', 8,
'16',
> > DECODE (sf_codigo_from_id (carpeta.subcodigo_gestion_id), '24', 5, '23',
> 4,
> > '22', 3, '21', 2, '20', 7, '19', 6, '18', 1,  999),  999) ASC, TRUNC
> > (carpeta.fecha_ultima_gestion) ASC,
> >
>
sf_importe_codigo(expediente.importe_pendiente,expediente.codigo_moneda_pend
> > iente_id,0) DESC, carpeta.alarma DESC
> >
> >
> >
>
>


0
Terry
4/16/2001 6:14:22 PM
The versions are:

PB.: 7.0.3. Build 10065
DB.: Oracle Personal Edition 8.1.5
OS: Windows 2000

I thinks that I don�t return nulls. If  I do datawindow select in SQL*Plus I
always get the rigth result.

Thanks to answer me.

"Terry Dykstra" <dontreply_tdykstra@cfol.ab.ca> escribi� en el mensaje
news:diQhxMqxAHA.274@forums.sybase.com...
> Most likely because you are hitting nulls somewhere.
>
> --
> Terry Dykstra (TeamSybase)
> Please state PB / OS / DB versions in your post.
> MySybase http://my.sybase.com/mysybase
> Search Deja: http://www.pfcguide.com/_newsgroups/search.asp
>
> "forums.sybase.com" <mamen@sicsa.net> wrote in message
> news:G#lkqgnxAHA.191@forums.sybase.com...
> > Could anyone help me, please???
> > Thanks.
> >   Mamen.
> >
> >
> >
> > "M.Carmen" <mamen@sicsa.net> escribi� en el mensaje
> > news:ORU5zTDvAHA.260@forums.sybase.com...
> > > I have a problem. I have a datawindow that returns around 14000 rows.
My
> > > connections is with Oracle. This DW in diferent executions returns
> > diferents
> > > number of rows and never chage are done in database. Why can be
this????
> > >
> > > Thanks.
> > >
> > > Datawindow select is:
> > >
> > > SELECT expediente.expediente_id,
> > >   sf_importe_preview (expediente.importe_pendiente,
> > > expediente.codigo_moneda_pendiente_id) importe_pendiente,
> > >   sf_formato_moneda_defecto (expediente.importe_pendiente,
> > > expediente.codigo_moneda_pendiente_id) importe_pendiente_st,
> > >   expediente.aportador_id,
> > >   expediente.numero_expediente,
> > >   expediente.numero_expediente_externo,
> > >   expediente.descripcion,
> > >   carpeta.fecha_limite_gestion,
> > >   TO_DATE (TO_CHAR (carpeta.fecha_alta, 'dd/mm/yyyy')) fecha_alta,
> > >   carpeta.programada,
> > >   carpeta.fecha_programada,
> > >   carpeta.carpeta_id,
> > >       carpeta.fecha_ultima_gestion,
> > >       carpeta.alarma,
> > >   carpeta.prioridad,
> > >   carpeta.gestor_busquedas_id,
> > >   sf_nemo_from_id (carpeta.codigo_gestion_id) codigo,
> > >   sf_nemo_from_id (carpeta.subcodigo_gestion_id) subcodigo,
> > >   DECODE (TO_CHAR (fecha_ultima_gestion, 'dd/mon/yyyy'), TO_CHAR
> (SYSDATE,
> > > 'dd/mon/yyyy'), 1, 0) tocado,
> > >   DECODE (gestor_busquedas_id, 0, 0, 1) enviado_busquedas,
> > >   sf_nombre_deudor (expediente.deudor_id) nombre_persona,
> > >   sf_numero_dni_deudor (expediente.deudor_id) numero_dni,
> > >   aportador.nombre_comercial
> > > FROM carpeta, expediente, aportador
> > > WHERE ((carpeta.gestor_asignado_id = 84)) AND (expediente.carpeta_id =
> > > carpeta.carpeta_id)
> > >   AND (expediente.aportador_id = aportador.aportador_id)
> > >   AND (expediente.devuelto = 0) AND (carpeta.visible = 1)
> > >  ORDER BY DECODE (carpeta.programada, 1, DECODE (SIGN
> > > (carpeta.fecha_programada - SYSDATE), -1, carpeta.fecha_programada -
> > > SYSDATE, 2), 1) ASC, carpeta.orden_tratamiento ASC, DECODE
> > > (sf_codigo_from_id (carpeta.codigo_gestion_id), '01', DECODE
> > > (sf_codigo_from_id (carpeta.subcodigo_gestion_id), '17', 13, '05', 11,
> > '03',
> > > 14, '02', 10, '01', 9,  999), '02', DECODE (sf_codigo_from_id
> > > (carpeta.subcodigo_gestion_id), '16', 12, '15', 15,  999), '15', 8,
> '16',
> > > DECODE (sf_codigo_from_id (carpeta.subcodigo_gestion_id), '24', 5,
'23',
> > 4,
> > > '22', 3, '21', 2, '20', 7, '19', 6, '18', 1,  999),  999) ASC, TRUNC
> > > (carpeta.fecha_ultima_gestion) ASC,
> > >
> >
>
sf_importe_codigo(expediente.importe_pendiente,expediente.codigo_moneda_pend
> > > iente_id,0) DESC, carpeta.alarma DESC
> > >
> > >
> > >
> >
> >
>
>


0
forums
4/17/2001 9:05:43 AM
Reply:

Web resources about - DataWindow Select - sybase.powerbuilder.general

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Intelligent Versus Surrogate Keys
Should I use business columns as primary key fields for tables in thedatabase, or generate artificial primary key values? When business-related ...

chevy volt
ProEXR File Description =Attributes= channels (chlist) compression (compression): Zip dataWindow (box2i): [0, 0, 5119, 2475] displayWindow (box2i): ...

Enable - A comprehensive solution for the localization of PowerBuilder applications Untitled Document ...
Enable is localization/ translation tool used by PowerBuilder developers to make their applications multilingual.Enable is a powerful tool that ...

comp.lang.clipper.visual-objects - Google Groups
comp.lang.clipper.visual-objects 1-20 von 33006 Themen werden angezeigt Integrity of a file marcosm...@gmail.com 09:35 Combobox value Lu 08:12 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
Developers can choose Win32 or newer style .Net development

PowerToTheBuilder - PowerBuilder UI Controls
HOME - COMPONENTS - PB UI DESIGNER - DOWNLOAD\PURCHASE - SUPPORT - FAQ - ABOUT Take Control of your UI with PB Ultimate Suite PowerToTheBuilder.com ...

Beautiful iPad Mini 3 Concept Reimagines Apple’s Tablet With iPhone 6 Design, Gold Color [Images]
The iPhone 6 may be grabbing all of the recent headlines due to its impending announcement, but spare a thought for those who prefer to stay ...

Java Networking - Real's HowTo
Real's HowTo Custom Search Java Language String and Number Applet AWT Swing Environment IO Javascript interaction JDBC Thread Networking JSP ...

Business Intelligence Products - Database Management, Data Warehousing & Mobility Software - Sybase Inc ...
Sybase offers a variety of Business Intelligence (BI) software like products for database management, data warehousing and mining, data integration ...

Resources last updated: 12/13/2015 3:03:24 AM