FiveTech Software tech support forums

MR Rao...

OLD - Don´t work key down or key UP


NEW - BUT don´t work oRs:bOnChangePage with key down or key UP


https://www.youtube.com/watch?v=DgP54iw ... e=youtu.be

CHANGE LINE 35 TO

I created an example in tdolphin

FW_DEMODB(“DLP”) – TDOLPHIN

https://www.youtube.com/watch?v=b9zHD-U-j2U&feature=youtu.be

#include "fivewin.ch"static oRsstatic oBrwstatic lPesquisa***************************************************************************function Main(&#41 ...

MR . RAO
PLEASE look SETWHERE IN TDOLPHIN
I explain :
Through setwhere I can do filter and pages and even order a grid by clicking on the header
VIDEO :
https://www.youtube.com/watch?v=ybPAC1_jm2M

1. HEADER E FOOTER CLICL ...

how to make REQUERY with pagination

ors := ::oSetup:oServer:RowSet("Select * from produtos ? order by descricao",{"where inactive = 'N'"}, 50) // pagination with 50 **** ERRO DON´T WORK... ***

ors:Requery("where name like '%PINAPPLE% '") // WITH PAGINATION 50

ors:Requery( "where Inactive = 'S ...

HOW TO MAKE PAGINATION WITH FILTER
oRs := oCn:RowSet( 'produtos', 10) //
oRs:setfilter("name $ 'PINEAPPLE')

1 -'AAA PINEAPPLE KG'
2 -BBB PINEAPPLE KG'
3 -'CCC PINEAPPLE KG'
.
.
.
99-'JUICE PINEAPPLE'

RETURN ONLY rows OF PAGE 1

Does not work the automatic page
what am I doing wrong ???

My table has 100 rows
Shows only 20 rows and when I press down arrow does not show a new page with 20 more rows



::oTable := oCn:RowSet( 'produtos', 20) // page with 20 rows DEFINE BRUSH OBRUSH COLOR RGB(220,220,220&#41 ...

METHOD 2 DON´T WORK


Method 2
--------
oRs := oCn:RowSet( "SELECT * FROM country ?", { "" } )
Later
oRs:ReQuery( { "WHERE name like '%REPLUBICA%' } )
Later
oRs:ReQuery( { "" } )
Later
oRs:ReQuery( { "WHERE age > 40" } )

And so it does not work either
oRs := oCn:RowSet( "SELECT * FROM country ...

HOW TO MAKE ?

IN TDOLPHIN
oQry := TDolphinQry():New("select * from country ", oServer )
oQry:setWhere("name like '%REPLUBLICA%'",.T.) // QUERY RESULT -> select * from country where name like '%REPLUBLICA%

to clean
oQry:setWhere("",.T.) // QUERY RESULT -> select * from country


IN TMARIADB ????

OK
thanks for the help

Just wanted to use by default my current system where each table has a class



If you can please provide a working example using the above class to explain its functionality, we try to suggest alternative approaches to achieve the same functionality without inheriting from ...

I'm using it this way and it's working !!!!

#Include "Fivewin.ch"#include "xbrowse.ch"//-----------------------------------------------------------------------//---- Classe DB_slbdaces//----//---- Luiz Antonio de Oliveira//---- Data : 23/06/2016 Hora : 22:52:14 ...

How to inherit the fwmariaconnect class ????

CLASS MYCLASS from fwmariaconnect // ( does not work )

class MYCLASS FROM TDOLPHIN // ( OK )

How would you look only with the .RES file PELLESC ?
I do not use .RC only .RES

Antonio Linares wrote:Si no usas un fichero RC entonces tienes que modificar el fichero make asi: