Search found 43 matches

by luiz53
Mon May 22, 2017 6:47 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWH: MySql/MariaDB: RowSet object
Replies: 48
Views: 15260

Re: FWH: MySql/MariaDB: RowSet object

MR Rao...

OLD - Don´t work key down or key UP

Code: Select all

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

Code: Select all

oRs:lAutoExpand   := .t.
 

https://www.youtube.com/watch?v=DgP54iw ... e=youtu.be
by luiz53
Thu May 18, 2017 1:23 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWH: MySql/MariaDB: RowSet object
Replies: 48
Views: 15260

Re: FWH: MySql/MariaDB: RowSet object

CHANGE LINE 35 TO

Code: Select all

   oRs:bOnChangePage = { || vsay := alltrim(STR(oRs:nCurrentPage))+" / "+alltrim( STR(oRs:nMaxPages)),;
                            oSay:refresh(),oBrw:Refresh() }
 
by luiz53
Thu May 18, 2017 12:43 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWH: MySql/MariaDB: RowSet object
Replies: 48
Views: 15260

Re: FWH: MySql/MariaDB: RowSet object

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 oRs static oBrw static lPesquisa *************************************************************************** function Main() **********...
by luiz53
Tue May 16, 2017 1:47 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWH: MySql/MariaDB: RowSet object
Replies: 48
Views: 15260

Re: FWH: MySql/MariaDB: RowSet object

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 ******************************************************************************...
by luiz53
Mon May 15, 2017 6:27 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWH: MySql/MariaDB: RowSet object
Replies: 48
Views: 15260

Re: FWH: MySql/MariaDB: RowSet object

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:Requer...
by luiz53
Mon May 15, 2017 5:58 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWH: MySql/MariaDB: RowSet object
Replies: 48
Views: 15260

Re: FWH: MySql/MariaDB: RowSet object

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
by luiz53
Mon May 15, 2017 1:36 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWH: MySql/MariaDB: RowSet object
Replies: 48
Views: 15260

Re: FWH: MySql/MariaDB: RowSet object

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) DEFINE DIALOG ::oDlg RES...
by luiz53
Sat May 13, 2017 1:45 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWH: MySql/MariaDB: RowSet object
Replies: 48
Views: 15260

Re: FWH: MySql/MariaDB: RowSet object

I´M SORRY MR. RAO.

I deleted my post because I found my mistake.

But your new post was a lot of help

FIVEWIN 17.03 !!!

nageswaragunupudi wrote:These are some examples
May I know if you are using FWH 17.04?
by luiz53
Fri May 12, 2017 6:21 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWH: MySql/MariaDB: RowSet object
Replies: 48
Views: 15260

Re: FWH: MySql/MariaDB: RowSet object

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 :...
by luiz53
Fri May 12, 2017 2:54 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWH: MySql/MariaDB: RowSet object
Replies: 48
Views: 15260

Re: FWH: MySql/MariaDB: RowSet object

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 c...
by luiz53
Mon Apr 24, 2017 12:07 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWHMARIADB Samples
Replies: 47
Views: 17659

Re: FWHMARIADB Samples

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 these...
by luiz53
Thu Apr 20, 2017 6:20 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWHMARIADB Samples
Replies: 47
Views: 17659

Re: FWHMARIADB Samples

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 //----------...
by luiz53
Thu Apr 20, 2017 1:18 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWHMARIADB Samples
Replies: 47
Views: 17659

Re: FWHMARIADB Samples

How to inherit the fwmariaconnect class ????

CLASS MYCLASS from fwmariaconnect // ( does not work )

class MYCLASS FROM TDOLPHIN // ( OK )
by luiz53
Thu Dec 29, 2016 10:44 am
Forum: FiveWin for Harbour/xHarbour
Topic: Borland makefile for Harbour + FWH + BCC7
Replies: 22
Views: 4336

Re: Borland makefile for Harbour + FWH + BCC7

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:
by luiz53
Tue Nov 01, 2016 8:43 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Button Bar JPG or PNG
Replies: 15
Views: 2296

Re: Button Bar JPG or PNG

Image