• 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)
mike S
mike S Accepted Answer Pending Moderation
  1. Wednesday, 19 October 2022 14:27 PM UTC
  2. PowerBuilder
  3. # 1

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.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 19 October 2022 14:00 PM UTC
  2. PowerBuilder
  3. # 2

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