On Sep 16, 2006, at 9:34 AM, [EMAIL PROTECTED] wrote:
You can do something like this:
Dim rs as Recordset = myDB.SQLSelect("SELECT * FROM xBlobs WHERE
Docid='" + myID + "'")
...
rs.Edit
rs.BlobColumn("blob1") = updatedPic1
rs.BlobColumn("blob2") = updatedPic2
rs.Update
db.Commit
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
Hi Marco,
thanks for your answer.
I experimented with what you suggested with no success.
The compiler complains that there is no such Method or Property.
Any other suggestion?
Marco was just showing you the general procedure for updating
existing records. You have to substitute your own properties or
variables for this to work.
Roger M. Clary
Class One Software
http://www.classonesoftware.com
[EMAIL PROTECTED]
Yes, I thought about that too, and tried a few more things. The
following works:
Dim rs as Recordset = myDB.SQLSelect("SELECT * FROM xBlobs WHERE
Docid='" + myID + "'")
...
rs.Edit
rs.Field("blob1").Value = updatedPic1
rs.Field("blob2").Value = updatedPic2
rs.Update
myDB.Commit
I was looking in the DatabaseField class for something to match the
BlobColumn. But discovered that the generic Value property works
without worrying about compensating for escape characters. The actual
data can be any binary stuff so, JPEGvalue is too restrictive.
--
Cheers,
Peter
TI PowerBook G4, 1GHz, 1GB RAM, OSX 10.3.9, RB2006r3 Pro
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
