Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Question Unanswered: Help to read BLOB using OLEDB

    Hi,
    sorry, but I have a TARZAN english, just I try... :-)
    Well, I have problem to read a BLOB using OLEDB, this is my code:

    Set sLogoEmpresa = ''
    If SqlPrepare( hSql, '
    SELECT logo_empresa
    FROM empresa
    INTO :sLogoEmpresa
    WHERE rut = :nPrmRutEmpresa' )
    If SqlSetLongBindDatatype( 1, DT_Binary )
    If SqlExecute( hSql )
    Set nEof = 0
    Call SqlFetchNext( hSql, nEof )
    If Not SalPicSetString( picLogoEmpresa, 3, sLogoEmpresa )
    Call SalMessageBox('No se pudo cargar la imagen','Error (Byte)',0)
    Else
    Call SalMessageBox( 'LongBindDatatype' ,'Error' ,0 )

    In run time, send error when call SqlExecute:
    "(-611) Scroll cursor can't select blob columns".

    I use Informix 9.4, TD 3.1, OLEDB. This code work ok in TD 1.5 (Router Native)

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hola,

    Por favor chequea que luego del insert no se este cerrando la transacción y por esto el cursor se cierra.
    También puede ocurrir que el resultado del SELECT te esta trayendo mas de una fila.

    Gustavo.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •