Re: PS_GENL_COMMENT

[csmyth <csmyth@IDIRECT.COM>]

Kristine,

The field COM.COMMENT_DT is a duplicate order key and that may be the problem.

Try this and see what you get displayed

  Let $Remarks = ' '

Begin-Select
COM.COMMENTS
  Let $Remarks = Substr(&COM.COMMENTS, 1, 30)
  Display $Remarks

FROM PS_GENL_COMMENT COM
WHERE COM.EMPLID = $Emplid
AND COM.COMMENT_DT = $Effdt
End-Select

Cameron

Kristine Brewer wrote:

> I have a custom sqr which selects from PS_GENL_COMMENT.  The first time the
> program is run, it's perfect.  If I delete or change the comments and re-run
> the program, the original comments (which no longer exist on the panel)
> still get selected.  I try doing the same select in query and in SQL+ and it
> works perfectly every time.  Here is the select in the program:
>
>   Let $Remarks = ' '
>
> Begin-Select
> COM.COMMENTS
>   Let $Remarks = Substr(&COM.COMMENTS, 1, 30)
>
> FROM PS_GENL_COMMENT COM
> WHERE COM.EMPLID = $Emplid
> AND COM.COMMENT_DT = $Effdt
> End-Select
>
> _________________________
> Kristine Brewer
> CSU Chancellor's Office
> Phone: (562) 951-4336
> Fax: (562) 951-4944
> Email: kbrewer@calstate.edu