ADOXB

ADOXB

Postby lucasdebeltran » Fri May 17, 2013 4: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: Select all  Expand view

    #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.
User avatar
lucasdebeltran
 
Posts: 1303
Joined: Tue Jul 21, 2009 8:12 am

Re: ADOXB

Postby Antonio Linares » Fri May 17, 2013 6:10 pm

regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42092
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: ADOXB

Postby lucasdebeltran » Fri May 17, 2013 6: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.
User avatar
lucasdebeltran
 
Posts: 1303
Joined: Tue Jul 21, 2009 8:12 am


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Antonio Linares, Google [Bot] and 89 guests