×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Operation is not supported on BLOB fields

Operation is not supported on BLOB fields

Operation is not supported on BLOB fields

(OP)
I'm trying to change the data in a memo field. I get this error though: Operation is not supported on BLOB fields.

I have this statement in the query: A, changeto D

Any idea how I can change the data?

RE: Operation is not supported on BLOB fields


A, changeto D

That just says if the field contents, IN WHOLE, are the character 'A', change the field contents to the character 'D'.

Is that what you wish?

Regardless, I don't believe you can change the contents of a Memo field with a query.

Try using a tcursor instead.

Tony McGuire
Stop Rob Bennett - http://www.notrob.info
"It's not about having enough time; we have the rest of our lives.  It's about priorities."

RE: Operation is not supported on BLOB fields

(OP)
Yes, that's what I would like to do.

I don't know anthing about the use of tcursor, can you tell me more about it and can you provide the syntax?

Thanks

RE: Operation is not supported on BLOB fields


I believe the below would do it.

Quote:


var
tc    tcursor
endvar
tc.open(":alias:tablename.db")
tc.edit()
scan tc for tc."fieldname".value="A" :
  tc."fieldname".value="D"
  try
    tc.unlockrecord()
  onFail
    ; your error handling here
    errorclear()
  endTry
endscan
tc.endedit()
tc.close()

Tony McGuire
Stop Rob Bennett - http://www.notrob.info
"It's not about having enough time; we have the rest of our lives.  It's about priorities."

RE: Operation is not supported on BLOB fields

(OP)
Thanks alot.  Where do I put this snippet of code now?  And how do I run it?

RE: Operation is not supported on BLOB fields


Put it anywhere that can execute code.

Pushbutton on a form, script, any object that can execute code.

Tony McGuire
Stop Rob Bennett - http://www.notrob.info
"It's not about having enough time; we have the rest of our lives.  It's about priorities."

RE: Operation is not supported on BLOB fields

(OP)
Thank you.  I just realized that I need to make this change only one a select group of records.  These records are in another table and the way to identify the records is by the letter D.  This table and the table that has the records that I need to change from A to D are linked by a common number.

RE: Operation is not supported on BLOB fields

(OP)
I tried the code above on a different table which also requires a one letter change and am getting this error message: An error was triggered in the 'edit' method on an object of TCursor Type.
This is what the code looks like:
method run(var eventInfo Event)
         
var
tc    tcursor
endvar
tc.open(":alias:employees.db")
tc.edit()
scan tc for tc."DStatus".value="D?" :
  tc."DStatus".value="D"
  try
    tc.unlockrecord()
  onFail
    ; your error handling here
    errorclear()
  endTry
endscan
tc.endedit()
tc.close()


endMethod

RE: Operation is not supported on BLOB fields


:alias: has to be replaced by the alias you use to point to the location of the table.

I think it time someone else take over explaining all this.

You really should pay someone to do this for you.

That, or go to http://pnews.thedbcommunity.com and ask this there; a lot of people doing Paradox.  Maybe in the programming group.

Tony McGuire
Stop Rob Bennett - http://www.notrob.info
"It's not about having enough time; we have the rest of our lives.  It's about priorities."

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close