Hi,
I have Bentley Map project, XFM features in DGN with mslinks to SQL Server 2014 (hybrid DGN + DB project).
Source problem is that I need to place a feature (cell) in two different modes:
Is anybody aware of some simple solution?
After some testing, I want to try an idea to have two different Insers SQL commands, one original with INSERT (new row is created) and second with UPDATE. They would be controlled by Criteria what SQL command will be sent to database.
Unfortunately I am not able to test this approach, because I am not able to find a way how to control the queries and select one only.
The project is huge and requires specifically configured dabase, but what I did in a simplified and anonymized form:
Now the situation is that no SQL command is sent to database, so it seems both criteria are evaluated as not valid.
Is it possible to test somehow whether the problem is in the criteria (e.g. wrongly defined) or e.g. it's bug when criterion using operation feature is set for SQL statement, it's not evaluated?
With regards,
Jan
Just a thought: Maybe SQL statements are cached when project is loaded and at this time the operation feature has no value and no criterion is evaluated as valid, and when the placement command is restarted, SQLs are not reevaluated?
Regards,
Bentley Accredited Developer: iTwin Platform - AssociateLabyrinth Technology | dev.notes() | cad.point