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?
This is not something we recommend you do. What are you trying to do so I can advise on how it can be done?
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.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.
The AutoCAD Plant 3D forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.
|AutoCAD Plant 3D General|