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
Our dbparm is just standard stuff( Database='xx-xxxx', Provider='SQLNCLI11' , TrustedConnection=1) AutoCommit is turned off, etc.
I also assume that you have SQLCA.DBMS ="SNC"?