MySQL, ADO and Browse

[R.F.]

Does anybody out there has the correct connection string to make a MySQL Recordset to be "browseable" ??????

I have browsed recordsets of Oracle, ADS, Access, SQL Server, and ALL these using the very same methodology, I mean modifying the movement blocks for the browse, and all worked as expecte, exept mysql.

Any workaround ?

[Rochinha]

Hi Rene

look this

Code: Select all  Expand view

    ...
    StrDatabase   := [SGEA]
    StrServer     := [127.0.0.1]
    StrUserID     := [root]
    StrUserPWD    := [root]

    StrTable      := [pessoas]
    StrField      := [estado]
    StrField2     := [nome]
    StrWhere      := StrField+[="PR"]

    StrConnection := [driver={MySQL ODBC 3.51 Driver};database=]+StrDatabase+[;server=]+StrServer+[;uid=]+StrUserID+[;pwd=]+StrUserPWD+[;option=35]
    StrSqlCommand := [SELECT * FROM ] + StrTable + [ WHERE ] + StrWhere

    oRs := TOleAuto():New( "ADODB.Recordset" )

    oRS:CursorType     := adOpenStatic
    oRS:CursorLocation := adUseClient
    oRS:LockType       := adLockPessimistic

    oRS:Open( StrSqlCommand, StrConnection, 1, 3 )
    ...


This help you?

[R.F.]

Thanks a lot !!!!!

I was missing the cursor location, I wonder why this was working on other databases.

[Rochinha]

Rene

With ADO you can work with various DBs

This is ShowDeBola!!!