Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Unanswered: truncated field?

    Hey all, I'm a newbie so I appreciate any help you can offer.

    I'm pulling employee information data from multiple tables and one of my fields (Supervisor) is returning as "***"

    I'm not sure if there is something I need to set, and I'm probably overlooking something obvious. The line that pulls the data from the other table is:

    AA$SIS$Get_superviser_name(std.superviser_number,s td.location,1)||','||

    (I have the SELECT portion formatted to output in a csv format)

    I'd appreciate any suggestions

    Thanks

    Dee

  2. #2
    Join Date
    Oct 2003
    Posts
    4

    Thumbs up Re: truncated field?

    Well, I've found out what the problem was.

    1) *** indicates an empty field
    2) Admin had 2 SQL accounts set up for me. These 2 accounts conflicted and restricted access to some tables. Once one of the accounts was deleted, the query ran correctly witht he expected outcome.

    Cheers
    Dee
    Last edited by psdcc; 10-09-03 at 09:00.

Posting Permissions

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