• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Does PB22 no longer supports the old PB =* outer join syntax?

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

Resolved Does PB22 no longer supports the old PB =* outer join syntax?

  1. Advice
0
Votes
Undo
  1. Vijay Jha
    Vijay Jha
  2. PowerBuilder
  3. Wednesday, 19 October 2022 13:42 PM UTC

Hi Team,

 

Does PB22 no longer supports the old PB =* outer join syntax?  Actually we have migrated our application from PB 2017 to PB 2022 nd it looks * outer join syntax is not doing the things so thought of checking with you ?

 

Thanks

Vijay Jha

Is native DPI scaling support on the roadmap for P...
Help with pbdwe.dll, versión: 21.0.0.1311 exceptio...
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 19 October 2022 14:00 PM UTC
  2. PowerBuilder
  3. # 1

Hi Vijay;

  Yes, PB 2022 still supports the older ASE, SS & SA DBMS join syntax ...

The above setting then generates the following setting ...

SQLCA.DBParm = "OJSyntax='PB'"

HTH

Regards .. Chris

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Wednesday, 19 October 2022 14:27 PM UTC
  2. PowerBuilder
  3. # 2

note that *= syntax has been removed by microsoft in current versions of sql server, and has been obsolete for many years

 

this is a fairly good write up:  SQL Server *= Operator? - Stack Overflow

 

all of these issues pertain to ase and sql anywhere even if they do support it.

 

 

Comment
Matt Balent
  1. Matt Balent
  2. Tuesday, 25 October 2022 21:19 PM UTC
Always a good idea to learn and use the ANSI standard JOIN syntax.
  1. Helpful
There are no comments made yet.
Vijay Jha
Vijay Jha Accepted Answer Pending Moderation
  1. Wednesday, 19 October 2022 14:39 PM UTC
  2. PowerBuilder
  3. # 3

Thanks Chris, I have manually added outer joins in the code  and removed =*  as we were using OJS as ANSI. It worked and now we are searching for all *= and =* so that we can replace it with appropriate OJS.

 

Thanks

Vijay Jha

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.