xBrowse with MariaDB

xBrowse with MariaDB

Postby wartiaga » Wed Mar 13, 2019 7:14 pm

Hi,

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

Thanks in advance
wartiaga
 
Posts: 210
Joined: Wed May 25, 2016 1:04 am

Re: xBrowse with MariaDB

Postby nageswaragunupudi » 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.

Code: Select all  Expand view

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
User avatar
nageswaragunupudi
 
Posts: 10620
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: xBrowse with MariaDB

Postby wartiaga » Thu Mar 14, 2019 5: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.

Code: Select all  Expand view

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!
wartiaga
 
Posts: 210
Joined: Wed May 25, 2016 1:04 am

Re: xBrowse with MariaDB

Postby nageswaragunupudi » Sat Mar 16, 2019 5:26 pm

Please see:

viewtopic.php?f=3&t=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
User avatar
nageswaragunupudi
 
Posts: 10620
Joined: Sun Nov 19, 2006 5:22 am
Location: India


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot], wilsongamboa and 43 guests