Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show only
|
Search instead for
Did you mean:
This page has been translated for your convenience with an automatic translation service. This is not an official translation and may contain errors and inaccurate translations. Autodesk does not warrant, either expressly or implied, the accuracy, reliability or completeness of the information translated by the machine translation service and will not be liable for damages or losses caused by the trust placed in the translation service.Translate
It seems like it should be simple, but I can't make the connection. The error is "Unable to set one or more links to active due to insufficient/invalid information. Setting them to inactive" Here's my query:
SELECT * FROM TEST WHERE "Struct_tblCurvedPlateParts.CurvedPlatePartName" = %prop("ShipConstructor","Part Name");
What am I missing? Is there a basic tutorial on connecting to and querying SQL server data? Thanks for any info
The first I can think of is the database table might have missed some items the SQL code requires. In addition, the SQL code is sensitive to localization. i.e. the properties names in the SQL code should match the display name of the properties as you can see in UI.
If none of the above helps, please do not mind I am directing you to the help of Data Tool, where you might find more info to diagnose the problem.
I no longer receive any errors but i am not seeing any of the datatools properties from my database. The linked fields are the same between Navisworks and the database. I'm not sure what the problem is.
![Autodesk Design & Make Report](https://forums.autodesk.com/t5/image/serverpage/image-id/1350519iCB55845EBFC43016/image-size/large?v=v2&px=999" "Autodesk Design & Make Report")