xBrowse with MariaDB

[wartiaga]

Hi,

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

Thanks in advance

[nageswaragunupudi]

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()
 

[wartiaga]

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!

[nageswaragunupudi]

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.