1. Chen Mey Lee
  2. PowerServer 2020 or older (Obsolete)
  3. Wednesday, 10 March 2021 05:37 AM UTC

Hi,

Stored procedure check null logic is not working in PowerServer (PB2021 beta version).

I have to replace check null logic with check blank space , any solution to fix it without changing stored procedure code ?

eg.1 

 INSERT INTO #decodes (Display, Data)
    SELECT RTRIM(col_value) + ' - ' + RTRIM(descr_long)
          ,RTRIM(col_value)
    FROM KL_CLIENT_PARMS.dbo.pMiscDecodes
    WHERE comp_nr = @default_comp_nr
    AND plan_nr = @plan_nr
    AND col_name = @field_source
    --AND RTRIM(LTRIM(col_value)) != NULL
    AND RTRIM(LTRIM(col_value)) != ''
    AND called_from = 'S'

eg.2

 -- IF rtrim(substring(@TRDA,52,1)) != NULL
    IF rtrim(substring(@TRDA,52,1)) != ''
             SELECT @DSHI = substring(@TRDA,52,1)

Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 10 March 2021 13:49 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Chen Mey, This is probably a beta bug.  Please open a support ticket.

Comment
  1. Chen Mey Lee
  2. Thursday, 11 March 2021 00:33 AM UTC
Bug 6256 created, thanks
  1. Helpful
There are no comments made yet.
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Thursday, 11 March 2021 07:04 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

Hi Chen,

We reproduced the issue. After analysis, we found that Set ANSI Null is on by default in ODBC driver which is used by PowerServer, and this is different from ASE native driver, which causes the issue, please follow the steps below to solve the issue.

1 Go to ODBC data source Administrator > Your data source > Connection tab to UNCHECK 'Set ANSI Null' option (as shown attached).

2 Restart SnapDevelop solution.

Regards,
ZhaoKai

Attachments (1)
Comment
  1. Chen Mey Lee
  2. Thursday, 11 March 2021 09:15 AM UTC
It worked. thank you very much,
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.