Hello, is there anybody who knows about examples of Autocad Plant3D triggers both using SQLLITE and SQL SERVER application?
First of all I've to create BOP trigger using SQL SERVER 2008 R2. In which database table should I insert the code; and the code is the same used for SQL LITE trigger?
thanks
mauro
This is not something we recommend you do. What are you trying to do so I can advise on how it can be done?
I'm interested in a trigger example for Microsoft SQL Server 2008 R2.
I cannot get it working. Who can help me?
In the Plant software, data integrity validation and rules are performed on the client thus allowing multiple back end databases (some without stored procedures, triggers, etc) to be used. There is also a caching mechanism on the local computer to enhance performance.
For those reasons, we do not support using triggers and stored procedures. Doing so may corrupt the project database and/or cause problems in the running software due to the caching mechanism becoming inconsistent with database changes being made on the back end.
May I recommend using the Plant SDK, specifically the .NET APIs with the root class being PnPDatabase. It is very similar to ADO.NET APIs. By using these APIs, the database can be modified in a consistent and supported manner.
Thanks