NasibKalsi
Programmer
Hi:
I am trying to update the blob field through odbc driver but gives 'Data type mismatch' error. I could use replace statement for the other fields and does work fine. For testing purposes I tried .t., 1. 0h, 0x, 'a' all gives the same error.
? vartype(blobfield) reports G
I tried converting filetostring(), but the same error. However, filetostring() works fine on the local table.
Backgroud: I am trying to put graphics files in the blob field on the mysql database, thinking it will eliminate the problem of 2.0GB limitation on the filesize.
I tried the search and first 100+ replies (could not find or missed) that could help this problem.
This is first time I am working with this, may be I am missing something basic. Any help, poiters will be appreciated.
Nasib Kalsi
I am trying to update the blob field through odbc driver but gives 'Data type mismatch' error. I could use replace statement for the other fields and does work fine. For testing purposes I tried .t., 1. 0h, 0x, 'a' all gives the same error.
? vartype(blobfield) reports G
I tried converting filetostring(), but the same error. However, filetostring() works fine on the local table.
Backgroud: I am trying to put graphics files in the blob field on the mysql database, thinking it will eliminate the problem of 2.0GB limitation on the filesize.
I tried the search and first 100+ replies (could not find or missed) that could help this problem.
This is first time I am working with this, may be I am missing something basic. Any help, poiters will be appreciated.
Nasib Kalsi
