>>>>Do you know what could be a problem here?
>>>
>>>Is the SeatMap column a memo field or general field? According to help for PicutreVal property the column can be a memo field but not a general field (because general fields store additional unrelated binary data).
>>
>>This is an interesting question. I think it is supposed to me Memo column and it is with the driver I'm using. But we found that the other computer uses different ODBC driver which may produce this column as General field. I'll ask them to re-create the ODBC connection.
>
>Or you can use a schema where you'd map this field as memo nocptrans (i.e. binary). The content isn't different, it's just treated differently on VFP's end.
How exactly I would do that?
The file is read with the sqlexec and then made updateable view.
If it's not broken, fix it until it is.
My Blog