We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Databases, Blob - How do I access?

Odie
Odie asked
on
Medium Priority
336 Views
Last Modified: 2010-04-10
How can I access my Blob Field I created.  I want to store/retrieve 1024 Bytes.  But I just seem to be too clumsy too store or retrieve anything from it (newbie-experience).

I'm working with C++B 3 on a Paradox 7 Table.

Thx
Comment
Watch Question

Commented:
I use the Borland Database Engine.  Get your hands on a copy of it.  It comes with the api and documentation for you to build classes for tables so you can get and put to a blob in a painless manner.  try www.inprise.com

Go to http://www.inprise.com/searchsite/
and enter 'Frameworks'  and check the Borland Database Engine checkbox

Then press search.

Commented:
Another decent reference at that site:

http://www.inprise.com/devsupport/bde/cppfiles.html

Author

Commented:
Um...  I should have mentioned that I'm using the BDE too.  But I'm too stupid too handle the TBlobField.

MyTable->FieldByName("MyBlobField")->...

then what do I do with this?

Commented:
I'll look into it!!  Do you use the frameworks code generator?

Author

Commented:
I don't know what it is.  (Guess I don't then.)

Commented:
I'll take a look this weekend...  oh i forgot I am going to be out of town this weekend. I guess I have to wait until monday.  HOpefully someone else will beat me and post your answer here.

In the mean time take a look at any of these functions in your documentation:

DbiAppendRecord: Appends a record to the end of the table associated with the given cursor.
DbiDeleteRecord: Deletes the current record of the given cursor.
DbiFreeBlob: Closes the BLOB handle located within the specified record buffer.
DbiGetBlob: Retrieves data from the specified BLOB field.
DbiGetBlobHeading: Retrieves information about a BLOB field from the BLOB heading in the record buffer.
DbiGetBlobSize: Retrieves the size of the specified BLOB field in bytes.
DbiGetField: Retrieves the data contents of the requested field from the record buffer.
DbiGetFieldDescs: Retrieves a list of descriptors for all the fields in the table associated with the cursor.
DbiGetFieldTypeDesc: Retrieves a description of the specified field type.
DbiInitRecord: Initializes the record buffer to a blank record according to the data types of the fields.
DbiInsertRecord: Inserts a new record into the table associated with the given cursor.
DbiModifyRecord: Modifies the current record of table associated with the cursor with the data supplied.
DbiOpenBlob: Prepares the cursor's record buffer to access a BLOB field.
DbiPutBlob: Writes data into an open BLOB field.
DbiPutField: Writes the field value to the correct location in the supplied record buffer.
DbiReadBlock: Reads a specified number of records (starting from the next position of the  cursor) into a buffer.
DbiSaveChanges: Forces all updated records associated with the cursor to disk.
DbiSetFieldMap: Sets a field map of the table associated with the given cursor.
DbiTruncateBlob: Shortens the size of the contents of a BLOB field, or deletes the contents of a BLOB field from the record, by shortening it to zero.
DbiUndeleteRecord: Undeletes a dBASE record that has been marked for deletion (a "soft"  delete).
DbiVerifyField: Verifies that the data specified is a valid data type for the field specified, and that all validity checks in place for the field are satisfied. It can also be used to check if a field is  blank.
DbiWriteBlock: Writes a block of records to the table associated with the cursor.


Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.