1. Hua Yan
  2. PowerBuilder
  3. Monday, 28 June 2021 21:02 PM UTC

Any search window in our system gets a search criteria with the DW query mode. But when a DW is in query mode I cannot specify any string value starting with 'IN-' in any field on the DW.

Can anyone point out what is going on and how to solve the issue?

 

Thanks ahead.

 

 

Attachments (1)
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 28 June 2021 21:17 PM UTC
  2. PowerBuilder
  3. # 1

Hi Hua;

  Just a guess ... I wonder if its because "IN" is an SQL "reserved" word?

Regards ... Chris

Comment
  1. Hua Yan
  2. Monday, 28 June 2021 21:27 PM UTC
Actually when I specify the value "IN" it will convert to "'IN'" with single-quotes, before and after. If I specify string "IN-xxxxxx" it will be rejected immediately.



  1. Helpful
  1. Chris Pollach @Appeon
  2. Monday, 28 June 2021 21:45 PM UTC
How does it reject the "IN-" ... by the DW column itself, when you take the DW out of QueryMode or when you try & execute a Retrieve() command?
  1. Helpful
  1. mike S
  2. Tuesday, 29 June 2021 00:46 AM UTC
it gets rejected when you tab off the field.



  1. Helpful
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Tuesday, 29 June 2021 00:46 AM UTC
  2. PowerBuilder
  3. # 2

the USER has to tell the dw how to handle it by entering either the keyword LIKE or an operator such as = ><

in-

does not work

=in-

DOES work

Comment
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.