How to insert/update data in blob field via SQL

[ketiv]

Hi,
I have a *.db file, inside are fields id(int) name1(string) name2(blob binary). Both "values" (name1 and name2) are the same, first in pure text, second in hex.
The problem is where I try add or modify data via SQL command. UPDATE in name1 is OK, but in name2 is failed.
I have a question:
which way I can insert/update data in blob field via SQL.

Best regards
Ketiv

 

[TonyMcGuire]

Are you using Paradox the Application?

I don't do SQL, but it sounds like maybe you are using ODBC to get to the Paradox Tables. Is that correct? If so, it sounds like a newer odbc may be needed.

(Just in case another can help, best to have all info avaialable.)

Tony McGuire

http://www.wjcitycouncil.com

"It's not about having enough time; we have the rest of our lives. It's about priorities.