Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Unanswered: Problems with strings

    after two afternoons of pounding one's forehead on one's desk I am asking for help here...

    I can't get a string to go into a table. I know sounds horribly complicated right?

    Here is an example of the string
    *** MASTER ***  June 8, 2001 at 12:14pm Imported from PROvantage on 6/8/0
    the field it is going into is a memo field, i'm positive the insert statement is correct because if I change the string to ' ' it works perfectly.

    why won't this insert!!!!

    Anyone have any ideas?

  2. #2
    Join Date
    Dec 2003

    Never mind

    After walkin away and talking with a co-worker who had no idea what I was doing i solved the problem.

    the last character in the string is chr(0), which I hadn't previously considered. stupid data...

    anyhoo, problem fixed.

Posting Permissions

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