1. Jhonns Salas
  2. PowerBuilder
  3. Monday, 20 June 2022 07:19 AM UTC

Hello,

Our team is having a problem inserting a record in a table with a auto increment column(table hint),

I made a test in my workstation with PB R3, and i did not have any error in execution time,

but the group using PB R2 is not able to insert a record due to it is necessary to add a WITH keyboard to the insert statement.

It happens in execution time, not in design.

Do you know the cause of this issue or how solve it?

Thanks for your support.

Regards....

Attachments (2)
Andreas Mykonios Accepted Answer Pending Moderation
  1. Monday, 20 June 2022 07:53 AM UTC
  2. PowerBuilder
  3. # 1

Hi.

From what I read, the error should somewhere before the index=0. I would review and compare settings in ole db provider on your machine and machines where the insert fails. I would also compare the generated sql.

Andreas.

Comment
  1. Andreas Mykonios
  2. Tuesday, 21 June 2022 08:03 AM UTC
What troubles me in this case is that support for Microsoft OLE DB Driver (MSOLEDBSQL) was introduced in R3. So I agree with Chris that you should go on to R3. Of course this may not be easy to do immediately. You may need to do some testing... In my opinion there is something else in the syntax that cause the problem. You get a "generic" message. Database interfaces do return sometimes messages that may be misleading. In my opinion this could be the case.

Andreas.
  1. Helpful
  1. Jhonns Salas
  2. Tuesday, 21 June 2022 19:20 PM UTC
Andreas,

A question, if OLE DB Driver (MSOLEDBSQL) was introduced in 2017 R3,

which build was that?

I suppose these drivers are more recommendable for Azure.

Thanks,
  1. Helpful
  1. Andreas Mykonios
  2. Wednesday, 22 June 2022 12:56 PM UTC
The MSOLEDBSQL that supports sql server up to 2019 was introduced in PB 2019 R3 initial release (2670, it was also available in beta but those runtimes are not intended for production). There was a MSOLE connector in previous releases, but the new one supports more features as far as I know. That may be the reason this issue happens only in lower versions than R3.

Andreas.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 20 June 2022 15:41 PM UTC
  2. PowerBuilder
  3. # 2

Hi Jhonns ;

  FWIW: Sounds like the easiest &  simple fix is to get all the PB developers on the latest R3 MR.

Regards ... Chris

Comment
There are no comments made yet.
Markus Eckert Accepted Answer Pending Moderation
  1. Tuesday, 21 June 2022 09:15 AM UTC
  2. PowerBuilder
  3. # 3

Hi Jhonns

Why do you even need an Index hint on an insert where you insert a single row using the VALUES construct?

I highly doubt that hint is even doing anything (except creating trouble in R2).

Regards,
Markus

Comment
  1. Jhonns Salas
  2. Tuesday, 21 June 2022 15:31 PM UTC
Markus,



The Index hint depends from another system, in .Net, and i am not able to get rid of it,

I will making more testing, and try the R3 version.



Thanks and regards,
  1. Helpful
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Tuesday, 21 June 2022 13:18 PM UTC
  2. PowerBuilder
  3. # 4

I agree with Markus: drop the index hint.


If you choose not to do so, then put a breakpoint in the code JUST before the problem occurs. Copy the SQL and all associated variables.

In the database tool of your choice run the SQL and work with it. Often, these tools will provide more information than the PB runtime exe. Even the PB Database Painter gives you more information, and tools like Oracle's SQL Developer are even better at returning useful information.

Comment
There are no comments made yet.
Jhonns Salas Accepted Answer Pending Moderation
  1. Tuesday, 28 June 2022 14:39 PM UTC
  2. PowerBuilder
  3. # 5

Hello,

After we updated to PowerBuilder 2017 R3 Universal Edition, the problem was fixed,

but in the process i found different types of behavior of the application in both version.

For now the only situation to resolve is set the correct PB virtual machine DLLs files,

because in the application environment we cannot install the PB Packager,

could you please provide me an updated list of those files for PB 2017R3.

 

Thank you for the support,

Comment
  1. John Fauss
  2. Tuesday, 28 June 2022 15:27 PM UTC
Look in PB Help for the topic named "runtime files". It lists the runtime DLL's used by PB and what they are required for.
  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.