Operation is not supported on BLOB fields

[needInfo25]

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?

 

[TonyMcGuire]

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.

 

[needInfo25]

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

 

[TonyMcGuire]

I believe the below would do it.

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.

 

[needInfo25]

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

 

[TonyMcGuire]

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.

 

[needInfo25]

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.

 

[needInfo25]

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

 

[TonyMcGuire]

: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.