topic-30095

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

Starting with ADO
Posted: Tue Feb 03, 2015 01:58 AM

Hi All,

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

which one to start?

(1) This?

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

(2) This:

Code (fw): Select all Collapse

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

Kind Regards,

Frances

Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

Enrico Maria Giordano

Posts: 9022

Joined: Thu Oct 06, 2005 08:17 PM

Re: Starting with ADO
Posted: Tue Feb 03, 2015 09:11 AM

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

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

fraxzi

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

Re: Starting with ADO
Posted: Wed Feb 04, 2015 03:34 AM

Enrico,

Thanks for the advice. Noted.

Kind Regards,

Frances

Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

FiveTech Support Forums

Continue the discussion