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

Resolved SyntaxfromSQL migration issue

  1. Issue
0
Votes
Undo
  1. Jean-Charles Fauchier
    Jean-Charles Fauchier
  2. PowerBuilder
  3. Tuesday, 12 March 2024 13:41 PM UTC

Hello,

 

I migrated an application from PB 2017 to PB 2022 and I observed a malfunction with the SyntaxfromSQL function.

In PB 2017 the dw generated had updateable capability and the columns was in edit mode with tabsequence > 0

In PB 2022 the dw has no updateable capability and columns have no tabsequence. (see attachment)

I saw the same issue when migrating to PB 2019.

Is it bug ?

 

Attachments (2)
SyntaxfromSQL_pb2017.png SyntaxfromSQL_pb2017.png
SyntaxfromSQL_pb2022.png SyntaxfromSQL_pb2022.png
How to handle nested SetRedraw() pairs, a modest p...
ORA-25412 - transaction replay disabled by call to...
Responses (4)
Jean-Charles Fauchier
Jean-Charles Fauchier Accepted Answer Pending Moderation
  1. Tuesday, 23 April 2024 15:49 PM UTC
  2. PowerBuilder
  3. # 1

Hi,

After making some basic tests I identified the issue.

If the SQL statement contains the owner of the table in Uppercase letters,  the SyntaxfromSQL function doesn't return the same syntaxe in PB 2022  than if the owner of the table is in lowercase letters (see attachment)

in PB 20217 it was not case sensitive.

Attachments (2)
UPPERCASE OWNER_ISSUE.png UPPERCASE OWNER_ISSUE.png
LOWERCASE_OWNER_SUCCESS.png LOWERCASE_OWNER_SUCCESS.png
Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 14 March 2024 23:48 PM UTC
  2. PowerBuilder
  3. # 2

Hi Jean-Charles;

  Did you also update the DB client ODBC driver(s) as well to the same PG version?

Regards ... Chris 

Comment
Jean-Charles Fauchier
  1. Jean-Charles Fauchier
  2. Friday, 15 March 2024 07:24 AM UTC
Hi Chris,



I'm using psqlODBC 13



Regards,

JC
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 15 March 2024 15:16 PM UTC
That is a recent PG driver - which is good!

I would suggest that you then create a small PB App test case and simple PG DB that replicates this issue.

Then open a Support Ticket and then attach the test case to that new ticket.

That will allow Appeon to recreate the problem for Engineering in order for them to properly diagnose this internally.

  1. Helpful
There are no comments made yet.
Jean-Charles Fauchier
Jean-Charles Fauchier Accepted Answer Pending Moderation
  1. Tuesday, 12 March 2024 15:05 PM UTC
  2. PowerBuilder
  3. # 3

Hi Chris,

 

Yes I migrated from the same machine without any modification and I execute both applications from the same machine. And I don't have the same behavior between the 2 applications. When I catch the SQL Syntaxe in debug I see the difference.

OS : Windows 10 22H2

DB client : PostgreSQL ODBC Driver (UNICODE)

DB Server : PostgreSQL 10.1

PB 2017 R3 Build 1858

PB2022 R2 Build 2819

 

 

 

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 12 March 2024 16:23 PM UTC
Correction ... PB 2022 R3 supports => PostgreSQL 12, 13, 14, 15 or 16
  1. Helpful
Jean-Charles Fauchier
  1. Jean-Charles Fauchier
  2. Tuesday, 12 March 2024 16:24 PM UTC
Thank you for your comments.

I will export my database locally in a more recent version of postgreSQL and I will get back to you
  1. Helpful
Jean-Charles Fauchier
  1. Jean-Charles Fauchier
  2. Thursday, 14 March 2024 09:45 AM UTC
Hi,



I migrated the database to postgresql 14.3 and I have the same issue in PB 2022 :



Powerbuilder 2017 :

Syntax = Select idclsrep,noclsrep,lbclsrep FROM my_table



Result of SyntaxFromSQL :

release 17;

datawindow(units=0 timer_interval=0 color=1073741824 processing=1 print.margin.bottom=96 print.margin.left=110 print.margin.right=110 print.margin.top=96 print.preview.buttons=no )

table(

column=(type=decimal(0) update=yes key=yes updatewhereclause = yes name=idclsrep dbname="idclsrep")

column=(type=decimal(0) update=yes updatewhereclause = yes name=noclsrep dbname="noclsrep")

column=(type=char(100) update=yes updatewhereclause = yes name=lbclsrep dbname="lbclsrep")

retrieve="Select idclsrep,noclsrep,lbclsrep FROM my_table"

update="my_table" updatewhere=1)

header(height=68)

detail(height=80)

column(band=detail id=1 x="14" y="8" height="64" width="411" tabsequence=10 alignment="1" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no )

text(band=header text="Idclsrep" x="14" y="8" height="52" width="411" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" alignment="2" name=idclsrep_t )

column(band=detail id=2 x="439" y="8" height="64" width="411" tabsequence=20 alignment="1" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no )

text(band=header text="Noclsrep" x="439" y="8" height="52" width="411" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" alignment="2" name=noclsrep_t )

column(band=detail id=3 x="864" y="8" height="64" width="2423" tabsequence=30 edit.limit=100 alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no )

text(band=header text="Lbclsrep" x="864" y="8" height="52" width="2423" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" alignment="2" name=lbclsrep_t )

htmltable(border="0" cellpadding="1" cellspacing="1" generatecss="no" nowrap="no")



Powerbuilder 2022 :

Syntax = Select idclsrep,noclsrep,lbclsrep FROM my_table



Result of SyntaxFromSQL :

release 22;

datawindow(units=0 timer_interval=0 color=1073741824 processing=1 print.margin.bottom=96 print.margin.left=110 print.margin.right=110 print.margin.top=96 print.preview.buttons=no )

table(

column=(type=decimal(0) updatewhereclause = yes name=idclsrep dbname="idclsrep")

column=(type=decimal(0) updatewhereclause = yes name=noclsrep dbname="noclsrep")

column=(type=char(100) updatewhereclause = yes name=lbclsrep dbname="lbclsrep")

retrieve="Select idclsrep,noclsrep,lbclsrep FROM my_table")

header(height=68)

detail(height=80)

column(band=detail id=1 x="14" y="8" height="64" width="411" alignment="1" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no )

text(band=header text="Idclsrep" x="14" y="8" height="52" width="411" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" alignment="2" name=idclsrep_t )

column(band=detail id=2 x="439" y="8" height="64" width="411" alignment="1" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no )

text(band=header text="Noclsrep" x="439" y="8" height="52" width="411" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" alignment="2" name=noclsrep_t )

column(band=detail id=3 x="864" y="8" height="64" width="2423" edit.limit=100 alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no )

text(band=header text="Lbclsrep" x="864" y="8" height="52" width="2423" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" alignment="2" name=lbclsrep_t )

htmltable(border="0" cellpadding="1" cellspacing="1" generatecss="no" nowrap="no")



  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 12 March 2024 14:46 PM UTC
  2. PowerBuilder
  3. # 4

Hi Jean-Charles;

  Is your migrated PB App using exactly the same ...

  1. DB Client software version / build?
  2. DBMS Server version / build?
  3. Identical SQLCA settings (IDE & runtime)
  4. Same DBMS Server instance for Unit Testing?
  5. Same O/S version / build?

Regards ... Chris

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.