General information
Category:
Coding, syntax & commands
>>>Have I have been deluding myself for years?
>>>
>>
>>Apparently. < g >
>>
>>>If I APPEND FROM from a table which has a memo field named MyNotes into a table with a character field named MyNotes, ought not the contents of MyNotes be transferred from the memo field into the character field, or at least as much as will fit?
>>
>>APPEND FROM/COPY TO don't process memo fields. Never have.
>>
>>Tamar
>
>Another interesting result is that ALTER TABLE ALTER COLUMN will retain the contents of a character field when it's converted to a memo, but not the other way.
>
>Cheers,
>
>Andrew
That's right, I've rarely if ever converted a memo field to a character field, but often the other way. I guess that's why I thought it would work. Modify structure doesn't work either.
Getting close to 'hanging up the spurs' I reckon.
Thanks for clarification.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only