Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved DW Query mode does not like value 'In-' value in any field

  1. How-to
0
Votes
Undo
  1. Hua Yan
    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)
2021-06-28 16_58_58-W100EE64-PB121 - Remote Desktop Connection.png 2021-06-28 16_58_58-W100EE64-PB121 - Remote Desktop Connection.png
  1. DataWindow
  2. PowerBuilder (Appeon)
  3. Query
Why is this Oracle .DMP File Being Created?
Question about shared objects
Responses (2)
mike S
mike S Accepted Answer Pending Moderation
  1. Tuesday, 29 June 2021 00:46 AM UTC
  2. PowerBuilder
  3. # 1

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.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 28 June 2021 21:17 PM UTC
  2. PowerBuilder
  3. # 2

Hi Hua;

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

Regards ... Chris

Comment
Hua Yan
  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
Chris Pollach @Appeon
  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
mike S
  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.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.