Manipulating Image data using VB & ODBC & IConnect
Posted in 1999
Has anyone tried to manipulate image data using VB methods getchunk, appendchunk? I'm having trouble with this. I created a small table with 2 columns in Informix: "create table test (col1 smallint, image byte, primary key (col1))" Then I'm using a small VB program to perform two operations: 1. Write a record with an image (using appendchunk on the Blob column) 2. Read that record. The problem is that when I try to read the record informix returns an error "invalid cursor position", nevertheless I can read perfectly well the value from col1. Here's the code: Dim vChunk as variant Dim sSql as string Dim rd1 as rdoresultset sSql = "SELECT * FROM test WHERE col=1" Set rd1 = rdoCon.OpenResultset(sSql, rdOpenForwardOnly) vChunk = rd1!imagem.GetChunk(ChunkSize) < -------- ERROR Please help me. This is my environment: Informix 7.31 UC2 for AIX Informix Connect 9.14 RDO2.0 ODBC Intersolv 3.00 32-bit Informix VB6 - SP2