• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • DW Query mode does not like value 'In-' value in any field

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.