hmg and oracle

Creative ideas/suggestions for HMG

Moderator: Rathinagiri

User avatar
Ismach
Posts: 79
Joined: Wed Nov 28, 2012 5:55 pm
DBs Used: DBF, mySQL, Mariadb, postgreSQL, Oracle, Db2, Interbase, Firebird, and SQLite
Location: Buenos Aires - Argentina
Been thanked: 7 times

Re: hmg and oracle

Post by Ismach » Wed Nov 14, 2018 1:17 am

En el caso de que no funcionara hay que cambiar asi

Code: Select all

    oRs := TOleAuto():New("adodb.recordset")
    // oRs:ActiveConnection(oOra)[b][/b]
    // oRs:CursorLocation(3)
    // oRs:CursorType := adOpenStatic
    // oRs:CursorLocation := adUseClient
    // oRs:LockType := adLockOptimistic

    oRs:Open(cSQL, oOra)
    IF  oRs:RecordCount = 0

        MsgInfo( "Producto Caja de Seguridad Inexistente", SISTEMA )
        fmCajas.txtA0090.Setfocus
        RETURN NIL

    ENDIF

User avatar
Ismach
Posts: 79
Joined: Wed Nov 28, 2012 5:55 pm
DBs Used: DBF, mySQL, Mariadb, postgreSQL, Oracle, Db2, Interbase, Firebird, and SQLite
Location: Buenos Aires - Argentina
Been thanked: 7 times

Post by Ismach » Wed Nov 14, 2018 1:17 am

obvio que el esta demas

User avatar
Ismach
Posts: 79
Joined: Wed Nov 28, 2012 5:55 pm
DBs Used: DBF, mySQL, Mariadb, postgreSQL, Oracle, Db2, Interbase, Firebird, and SQLite
Location: Buenos Aires - Argentina
Been thanked: 7 times

Post by Ismach » Wed Nov 14, 2018 1:28 am

en el caso de que no funcione se ebe cambiar a:

Code: Select all

    oRs := TOleAuto():New("adodb.recordset")
    // oRs:ActiveConnection(oOra)
    // oRs:CursorLocation(3)
    // oRs:CursorType := adOpenStatic
    // oRs:CursorLocation := adUseClient
    // oRs:LockType := adLockOptimistic

    oRs:Open(cSQL, oOra )
    IF  oRs:RecordCount = 0

        MsgInfo( "Producto Caja de Seguridad Inexistente", SISTEMA )
        fmCajas.txtA0090.Setfocus
        RETURN NIL

    ENDIF
aguardo sus comentarios

User avatar
dragancesu
Posts: 581
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 16 times
Been thanked: 111 times

Post by dragancesu » Wed Nov 14, 2018 1:32 pm

Thank you, I will try

Have you version with OCI?

User avatar
Ismach
Posts: 79
Joined: Wed Nov 28, 2012 5:55 pm
DBs Used: DBF, mySQL, Mariadb, postgreSQL, Oracle, Db2, Interbase, Firebird, and SQLite
Location: Buenos Aires - Argentina
Been thanked: 7 times

Post by Ismach » Wed Nov 14, 2018 1:40 pm

Nop! I don't use OCI,
I'm using WINOLE via ADODB ( conector nativo de windows )
provider="MSDAORA.1"

User avatar
Ismach
Posts: 79
Joined: Wed Nov 28, 2012 5:55 pm
DBs Used: DBF, mySQL, Mariadb, postgreSQL, Oracle, Db2, Interbase, Firebird, and SQLite
Location: Buenos Aires - Argentina
Been thanked: 7 times

Post by Ismach » Wed Nov 14, 2018 1:44 pm

more info : "Microsoft OLE DB Provider for Oracle Overview"
https://docs.microsoft.com/en-us/sql/ad ... erver-2017

User avatar
Ismach
Posts: 79
Joined: Wed Nov 28, 2012 5:55 pm
DBs Used: DBF, mySQL, Mariadb, postgreSQL, Oracle, Db2, Interbase, Firebird, and SQLite
Location: Buenos Aires - Argentina
Been thanked: 7 times

Post by Ismach » Wed Nov 14, 2018 1:46 pm

Lo que si se necesita es compilar las libs

c:\MiniGUI\SOURCE\HbOLE\
y
c:\MiniGUI\SOURCE\AdoRDD\

Post Reply