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

Resolved Table name in syntax from syntaxfromsql

  1. Issue
0
Votes
Undo
  1. Pascal Leblanc
    Pascal Leblanc
  2. PowerBuilder
  3. Wednesday, 8 July 2020 20:54 PM UTC

Hi,

  We are several developers using PB2019.2170, all on Windows 10, all using SAP SQL Anywhere 17.4003 (and the same db file).

  On only one instance, when using dw_1.syntaxfromsql(ls_sql), the name of the columns returned are composed in the form 'table_name'_'col_name' but for all other devs, the syntax returned is only 'col_name'. This cause several errors for this developer because later in the code, we access the datawinow using ony the column name.

  Is there some ODBC, .ini file or some other settings that control this behavior ?

Thank you.

 

Automatically generate schema for Datawindow
PowerBuilder se cierra al tratar de abrir cualquie...
Responses (5)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 8 July 2020 21:01 PM UTC
  2. PowerBuilder
  3. # 1

Hi Pascal;

   This can happen to any PB App regardless of the DBMS used if the instance of the DB the App is now communicating to and its associated login user ID do not have DBO (DB Owner) privileges. When this happens, the PB DW run-time starts adding table names on-the-fly to qualify the DB entity.

Regards ... Chris

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 6 October 2023 20:41 PM UTC
Hi Fabio;

Please open a support ticket for this and if possible, attach a small PB App test case that replicates this issue on the current PB Demo 2022 R2 (SA) test database.

Regards ... Chris
  1. Helpful
Vijay Kumar
  1. Vijay Kumar
  2. Wednesday, 8 November 2023 10:39 AM UTC
i am creating a datawindow through syntaxfromsql and updating after some setting values.But it is giving error , could you please help on this.
  1. Helpful
John Fauss
  1. John Fauss
  2. Wednesday, 8 November 2023 14:30 PM UTC
Your question cannot be answered in its present form, given how little information you have supplied. It's as if I said "My car is broken... can you tell me how to fix it?"

I think you will have a much better chance of getting a response if you: (1) Post your question in a separate/new thread instead of hijacking an existing thread, particularly since this one has not been updated in three years. (2) Include critical additional details, such as PB version/release/build, DBMS vendor and version, the SQLCA connection properties being used (mask any sensitive info, such as passwords, etc.), (3) The SQL syntax and/or the code where SyntaxFromSQL is being called, and most importantly, (4) include the error message(s).
  1. Helpful
There are no comments made yet.
Pascal Leblanc
Pascal Leblanc Accepted Answer Pending Moderation
  1. Thursday, 9 July 2020 12:16 PM UTC
  2. PowerBuilder
  3. # 2

Hi Chris,

  This is what I was also thinking at first, but I copied my colleague database file to my pc, and using the same DB credential, I do not have this behavior. Aslo tried my copy of the DB on is PC, and it's not working, so it's not a DB owner privileges issue.

  We also tested connecting to a network DB at the same time, using the same credential, using the same built application (not from PB runtine) and it's working fine on my pc but not on his.

  The only thing I can think of is there is some type of config mismatch somewhere on his pc.

Thanks

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 9 July 2020 17:41 PM UTC
Hmmm ... could be a mismatch either in the PBOBD190.ini file's settings for SA or a different DSN setting between your PC and your co-workers. I would check & compare those areas next. HTH
  1. Helpful
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Thursday, 9 July 2020 21:02 PM UTC
  2. PowerBuilder
  3. # 3

that is just the way it works.  you need to enter a bug report and maybe they will fix it.

syntaxfromsql is useful tool, but you might be better off just writing your own since the built in one isn't all that good.

 

here are some related bugs 

https://www.appeon.com/standardsupport/search/view?id=3859

https://www.appeon.com/standardsupport/search/view?id=3860

Comment
There are no comments made yet.
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Saturday, 11 July 2020 06:38 AM UTC
  2. PowerBuilder
  3. # 4

IF there are more tables involved, join, then there is a chance of prefixing table names along with column name(s).  Just check whether that particular user is using dw's that having more than one table.

 

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 10 November 2023 17:51 PM UTC
  2. PowerBuilder
  3. # 5

I've seen SyntaxFromSql behaving differently (regarding the table names being included or not), depending on which client version of Oracle was installed. SAME code!

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.