FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour ADOXB
Posts: 1303
Joined: Tue Jul 21, 2009 08:12 AM
ADOXB
Posted: Fri May 17, 2013 04:57 PM
Hello,

Does anybody have latest ADOXB functions?. It seems to me an easier way to start using ADO.

Look at the commands:

Code (fw): Select all Collapse
    #command ADO CONNECT <StrDriver> [<disconected:DISCONECTED>] => ADOCONNECT( <StrDriver>, [<.disconected.>] )
    #command ADO DISCONNECT             => ADODISCONNECT()
    #command ADO APPEND BLANK           => ADOAPPEND()
    #command ADO EDIT                   => ADOEDIT()
    #command ADO COMMIT [<save:SAVE>]   => ADOCOMMIT( [<.save.>] )
    #command ADO SKIP                   => ADOSKIP( 1 )
    #command ADO SKIP <num>             => ADOSKIP( <num> )
    #command ADO DELETE                 => ADODELETE()
    #command ADO REPLACE <f1> WITH <v1> => ADOREPLACE( <(f1)>, <v1> )
    #command ADO GOTOP                  => ADOGOTOP()
    #command ADO GOBOTTOM               => ADOGOBOTTOM()
    #command ADO SET FILTER TO          => ADOSETFILTER()
    #command ADO SET FILTER TO <xpr>    => ADOSETFILTER( <xpr> )
    #command ADO SAVE <(CfILE)>         => ADOSAVE( <(CfILE)> )
    #command ADO EXECUTE <*Sql*>        => ADOEXECUTE( <(Sql)> )
    #command ADO LOCATE <xpr>           => ADOLOCATE( <xpr> )
    #command ADO REGLOCK                => ADOREGLOCK()
    #command ADO CLOSE                  => ADOCLOSE()
    #command ADO CLOSE ALL              => ADOCLOSEALL()
    #command ADO USE                    => ADOUSE()
    #command ADO USE <(StrDatabase)> [<shared:SHARED>] => ADOUSE( <(StrDatabase)>, [<.shared.>] )
//  #command ADO SORT ON [<(cF)>][<(x)>] => ADOSORT( [<(cF)>][, <(x)>] )
    #command ADO SELECT <(cRecordSet)>  => ADOSELECT( <(cRecordSet)> )

    #xcommand ADO SQL DELETE <*cSQL*>   => ADOEXECUTE( 'DELETE '+ <(cSQL)> )
    #xcommand ADO SQL INSERT <*cSQL*>   => ADOEXECUTE( 'INSERT '+ <(cSQL)> )
    #xcommand ADO SQL UPDATE <*cSQL*>   => ADOEXECUTE( 'UPDATE '+ <(cSQL)> )
    #xcommand ADO SQL ALTER  <*cSQL*>   => ADOEXECUTE( 'ALTER ' + <(cSQL)> )
    #xcommand ADO SQL CREATE <*cSQL*>   => ADOEXECUTE( 'CREATE '+ <(cSQL)> )
    #xcommand ADO SQL DROP   <*cSQL*>   => ADOEXECUTE( 'DROP '  + <(cSQL)> )
    #xcommand ADO SQL RENAME <*cSQL*>   => ADOEXECUTE( 'RENAME '+ <(cSQL)> )
    #xcommand ADO SQL UPDATE <*cSQL*>   => ADOEXECUTE( 'UPDATE '+ <(cSQL)> )
    #xcommand ADO SQL GRANT  <*cSQL*>   => ADOEXECUTE( 'GRANT ' + <(cSQL)> )
    #xcommand ADO SQL REVOKE <*cSQL*>   => ADOEXECUTE( 'REVOKE '+ <(cSQL)> )


Thank you. Best regards,
Muchas gracias. Many thanks.



Un saludo, Best regards,



Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]



Implementando MSVC 2010, FWH64 y ADO.



Abandonando uso xHarbour y SQLRDD.
Posts: 44162
Joined: Thu Oct 06, 2005 05:47 PM
Re: ADOXB
Posted: Fri May 17, 2013 06:10 PM
regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 1303
Joined: Tue Jul 21, 2009 08:12 AM
Re: ADOXB
Posted: Fri May 17, 2013 06:56 PM

Antonio,

Thanks but links don´t work and the code is from 2007. Now it does not work fine with latest Harbour due latest changes in ActiveX and Ole.

But it will be a great approach to have such commands. I see the idea of a full ADO/SQLRDD is hard to accomplish, but to have a set of commands as regular DBF commands will help to use ADO.

What do you think?.

Best regards,

Muchas gracias. Many thanks.



Un saludo, Best regards,



Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]



Implementando MSVC 2010, FWH64 y ADO.



Abandonando uso xHarbour y SQLRDD.

Continue the discussion