Starting with ADO

[fraxzi]

Hi All,

I'm new to FWH ADO and I hope to have a good start.

which one to start?

(1) This?

Code: Select all  Expand view

oRS := CreateObject( "ADODB.Recordset" )
oRS:Open( 'SELECT * FROM mytable',  'Provider=SQLOLEDB;Data Source=mySQL2012server;Initial Catalog=mysqldb;uid=sa;pwd=password')
 

(2) This:

Code: Select all  Expand view

  oCn := FW_OpenAdoConnection(  'Provider=SQLOLEDB;Data Source=mySQL2012server;Initial Catalog=mysqldb;uid=sa;pwd=password', .T.)
  oRs := FW_OpenRecordSet( oCn, 'SELECT * FROM mytable' )
 

[Enrico Maria Giordano]

Frances,

I prefer to not hide frameworks under other functions or classes. At least, you can find a lot of docs about ADO that you can use almost directly.

EMG

[fraxzi]

Enrico,

Thanks for the advice. Noted.