November 11th, 2004, 04:36 PM
Updating Blobs and Memos in Local SQL
I am having difficulty copying blob and memo fields from one a field in one table to another. Normally I use local SQL to manipulate my database tables, but I haven't found a statement that will let me update blob or memo fields. I usually get an error stating the capability is not supported.
For reference my statements look like this:
SET Blob = (SELECT ADifferentBlob FROM "\\SERVER\Folder\ADifferentTable.db")
WHERE TableID > Value
I would prefer to make the change through SQL instead of writing an app if possible.