Results 1 to 4 of 4

Thread: Update query updating MEMO field without destroying contents?

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2002
    Location
    New Orleans
    Posts
    9

    Update query updating MEMO field without destroying contents?

    Is it possible for a simply UPDATE script to update a memo data field withOUT destroying the current contents of said field?

    Thanks!

    Jonathan

  2. #2
    Hyperactive Member
    Join Date
    Sep 2001
    Location
    Orlando
    Posts
    392
    Do you mean adding to the content? Or modifying the existing content?
    Abu Haider
    ____________________________
    100% Data Validation for the MS DataGrid Control. Plus Support for Custom and Foreign Lists, DatePicker and much more...
    The DataGridEnhancer


    I often point to a place where the problem has been discussed, instead of giving you the code that solves it. This is for good, may be you will understand some day...

  3. #3

    Thread Starter
    New Member
    Join Date
    Jan 2002
    Location
    New Orleans
    Posts
    9
    Originally posted by Abu haider
    Do you mean adding to the content? Or modifying the existing content?
    Adding to.

    Thanks,

    JMR

  4. #4
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    wouldn't it

    be something like :

    Update table Set field1=field1 & "New addition";

    Regards

    Vince

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width