Clase con funciones para ADO

[Compuin]

Hola Foro

Existe alguna clase que agrupe las funciones para ADO sin tener que llamarlas directamente?

[Rick Lipkin]

Look for AdoFunc.prg in the Samples folder .. \source\function

Rick Lipkin

[Compuin]

Thanks

I already check them. I was trying to find a class or something similar to use it instead FW_ function

[Rick Lipkin]

Here is my original post ( some years ago ) using native Microsoft Ado Class's and methods .. Rao has done a great job with the wrappers found in AdoFunc.Prg ... Here is the FiveWin Wili on ADO.

Rick Lipkin

http://wiki.fivetechsoft.com/doku.php?i ... ted_stuffs

[jbrita]

*** Constant Group: CursorTypeEnum
#command ADO USE <f1> INDEX <v1> LIMITE <l1> => ADOUSE( <(f1)>, <v1>, <l1> )
#command ADO REPLACE <f1> WITH <v1> => ADOREPLACE( <(f1)>, <v1> )
#command ADO COMMIT => ADOSAVE()
#command ADO SELECT <cRecordSet> => ADOSELECT( <cRecordSet> )
#command ADO APPEND BLANK => ADOAPEND()
#command ADO CLOSE <cRecordSet> => ADOCLOSE( <cRecordSet> )
#command ADO DELETE <cRecordSet> => ADODELETE( <cRecordSet> )
#command ADO EXECUTE <*Sql*> => ADOEXECUTE( <(Sql)> )
#command ADO GO TOP <cRecordSet> => ADOGOTOP( <cRecordSet> )
#command ADO LOAD <cRecordSet> => ADOLOAD( <cRecordSet> )

algo asi

[Compuin]

Hola,

Me refiero a algo como esto

Code: Select all  Expand view

#Include "fivewin.ch"

CLASS TSqlServer
   Data oCon
   Data cHost  
   Data cDatabase
   Data cUser      
   Data cPass      
     
   METHOD New(Host, Database, User, Pass) CONSTRUCTOR
   METHOD CreateDatabase()
   METHOD GetTables()
   METHOD Open(cTable)
   METHOD Query(cSql)
   METHOD Exec(cSql)
   METHOD GetStruct(cTable)
   METHOD ImportFromDbf(cFile)
ENDCLASS

Code: Select all  Expand view

METHOD New(Host, Database, User, Pass) CLASS TSqlServer
...
     
::oCon :=  Fw_OpenAdoConnection(cString,.T.)
...

Return Self