• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Getting db error when inserting row, but I can do it other places.

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

Resolved Getting db error when inserting row, but I can do it other places.

  1. Advice
1
Votes
Undo
  1. Floyd Edwards
    Floyd Edwards
  2. PowerBuilder
  3. Thursday, 18 April 2019 20:40 PM UTC

Okay, back again.... seems that PB as real attitude with me.. :O)

 

When I am inserting a row into the table I get the following error:

- SQLSTATE = 42000
--Microsoft SQL Server Native Client 10.0
--INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.

--No changes made to database.

 

When I take the SQL generated by PB, and run it in SSMS, It works.

If I go to the PB database painter it works

If I insert it into the datawindow (in PB), it works...

 

I can not find a single code of line that deals with the QUOTED_IDENTIFIER', my illustrious DB's tells me that everything is fine on the database (time will tell)..

Any suggestions?

 

Thanks, 

Floyd

Why the LOWERED! BORDER in the DataWindow works i...
EAServer Database Connection
Responses (3)
Markus Eckert
Markus Eckert Accepted Answer Pending Moderation
  1. Wednesday, 24 April 2019 08:14 AM UTC
  2. PowerBuilder
  3. # 1

If you're using SQL Native Client you need to add this option to your dbparm string to enable the Quoted_Identifier setting.

 

,DelimitIdentifier=1

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Friday, 19 April 2019 15:37 PM UTC
  2. PowerBuilder
  3. # 2

as per the error message, the table you are inserting into apparently has 'indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.'

 

according to the error message you will need to set quoted identifiers (probably to 'on') in order to insert into this particular table due to how the DBA has things setup

or have the dba remove/changed the indexed view and/or computed columns etc.

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 18 April 2019 20:54 PM UTC
  2. PowerBuilder
  3. # 3

Hi Floyd;

1)  What version of SQL Server are you  using?

2)  What values are your setting in your PB App for SQLCA?

Regards ... Chris

 

Comment
Floyd Edwards
  1. Floyd Edwards
  2. Thursday, 18 April 2019 22:05 PM UTC
We are on SQL 2016



Our dbparm is just standard stuff( Database='xx-xxxx', Provider='SQLNCLI11' , TrustedConnection=1) AutoCommit is turned off, etc.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 18 April 2019 22:34 PM UTC
Hmmm ... If your getting the message "Microsoft SQL Server Native Client 10.0", I wonder if your actually using Provider='SQLNCLI10' ?

I also assume that you have SQLCA.DBMS ="SNC"?
  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.