FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour xBrowse with MariaDB
Posts: 253
Joined: Wed May 25, 2016 01:04 AM
xBrowse with MariaDB
Posted: Wed Mar 13, 2019 07:14 PM

Hi,

How the best away to create a xbrowse with some MariaDb File/Fields?

Thanks in advance

Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: xBrowse with MariaDB
Posted: Thu Mar 14, 2019 12:28 AM
Exactly the same way as we create xbrowse for DBF, TDatabase, ADO, Array, etc.
Syntax of XBrowse is identical for all.
oRs := oCn:RowSet( "select first,last,city from customer" )

@ 20,20 XBROWSE oBrw SIZE w,h PIXEL OF oDlg ;
   DATASOURCE oRs ;
   COLUMNS "FIRST", "CITY" ;
   CELL LINES NOBORDER

oBrw:CreateFromCode()
Regards



G. N. Rao.

Hyderabad, India
Posts: 253
Joined: Wed May 25, 2016 01:04 AM
Re: xBrowse with MariaDB
Posted: Thu Mar 14, 2019 05:19 PM
nageswaragunupudi wrote:Exactly the same way as we create xbrowse for DBF, TDatabase, ADO, Array, etc.
Syntax of XBrowse is identical for all.
oRs := oCn:RowSet( "select first,last,city from customer" )

@ 20,20 XBROWSE oBrw SIZE w,h PIXEL OF oDlg ;
   DATASOURCE oRs ;
   COLUMNS "FIRST", "CITY" ;
   CELL LINES NOBORDER

oBrw:CreateFromCode()
Thank you Nages, I will display a browse and some buttons linke insert, delete and edit. I use tdabase with dbfs to display the fields e save or changes datas, in this case how the best away with fivewin mariadb functions? Thank you again!
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: xBrowse with MariaDB
Posted: Sat Mar 16, 2019 05:26 PM

Please see:

viewtopic.php?f=3t=36903

We strongly recommend this approach for browsing and editing records for any database including MariaDB. Please use the template.

Please feel free to ask any doubts or questions.

&

Regards



G. N. Rao.

Hyderabad, India

Continue the discussion