Wednesday, August 10, 2011

Power Builder::Tips

DropDown ListBox
http://kell-developer.blogspot.com/2009/09/cargar-una-tabla-un-dropdownlistbox-de.html


Clear datawindow
long ll_i, ll_rc

ll_rc = dw_1.RowCount()

for ll_i = 1 to ll_rc
dw_1.deleterow(1)
next

dw_1.AcceptText()
dw_1.Update(True, True)

--or--

dw_1.Reset() //will never delete the rows from DB, It will just clear the datawindow buffers.


Work with dates
========================================================
dt_today = today()
li_maand = month(dt_today )
li_jaar = year(dt_today )
li_dag = day(dt_today )


apply filter
========================================================
ls_filtro = "columna1 > 100 and columna2 > 30"

dw_1.SetFilter(ls_filtro)

dw_1.Filter( )




references
[0] http://powerbuilder-undiaalavez.blogspot.com/

[1] Tutorial Power Builder 9.0 http://edyovando.galeon.com/INICIO.HTML
[2] Trucos datawin
http://infolenguajes.galeon.com/datawin.htm
[3] http://kell-developer.blogspot.com/2009/09/cargar-una-tabla-un-dropdownlistbox-de.html

[4] List of Functions Available in Datawindow Expressions
http://pbbraindump.wordpress.com/2008/05/15/list-of-functions-available-in-datawindow-expressions/
[5] http://solocodigofuente.com/ejemplos-de-codigo-fuente-en-visual-basic-net/uso-del-control-dropdownlistbox-listbox-listview-de-power-builder/
[6] http://powerbuilder-undiaalavez.blogspot.com/2011_02_01_archive.html

http://ingpcastillo.com/personal/Manual/MANUAL_DE_POWER_BUILDER.pdf
http://sergioor.blogspot.com/2008/02/funciones-principales-de-un-datawindows.html
http://www.todoexpertos.com/categorias/tecnologia-e-internet/programacion/power-builder/respuestas/2317534/datawindows-avanzado



http://sergioor.blogspot.com/2008/02/funciones-principales-de-un-datawindows.html

http://es.scribd.com/doc/6878574/Powerbuilderuso-de-Cursores
http://groups.google.com/group/sybase.public.powerbuilder.database/browse_thread/thread/159c2bf7ef4f114e?pli=1


No comments:

Ubuntu Forware port 80

  #!/bin/bash iptables -t nat -A PREROUTING -i eth0 -p tcp --dport 80 -j REDIRECT --to-port 8069 iptables -t nat -A PREROUTING -i eth0 -p tc...