- Floyd Edwards
- PowerBuilder
- Wednesday, 3 April 2019 05:13 PM UTC
Okay here is my issue,
I am trying to either update a row or insert a row into the database using a data window. I have made sure that all the update properties are set correctly. Everything looks good.. then when I run the app, 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.
This is the SQL that the data window created:
INSERT INTO dbo.Year (YearID, SchoolYear, BeginDate, EndDate, ReportDate, CutOffDate, EvaluationStartDate, EvaluationCutOffDate, LoadStartDate, LoadEndDate )
VALUES ( 2020, '2020', '2019-07-01 00:00:00.000','2020-06-30 00:00:00.000','2020-06-30 00:00:00.000','2020-06-30 00:00:00.000','2020-03-01 00:00:00.000','2020-06-30 0:00:00.000','2020-03-01 00:00:00.000','2020-06-30 00:00:00.000')
I checked the DB and the Quoted Identifier is set to True....
When I go into SSMS and execute the SQL, it works.......
So I am thinking I may not have my DB connection set up correctly....
Any Advice?
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.