Hello.
I want to read feature propertу in Bentley Map, but the object created in bentley powerMap. I can see only mslink, another information does not display. How can i read it?
Mira
Mira;
Unless I am wrong, it sounds like you have a feature that has a database linkage ( mslink is the key field). When you provide this to other applications, users, etc. you must supply both the drawing and the database, since the database table/record contains the rest of the attributes.
HTH
Jerry
Hello Jerry,
i'm sorry for my english, I hope we can understand each other. Bentley PowerMap has linkage with the MDB. And feature property were registered in MDB. Bentley Map has linkage with the database on SQL-server. I copy feature property from MDB to SQL. When I read feature propertу in Bentley Map I get only № mslink, another field stayed empty. Why?
Thank you
Mira: Bentley PowerMap has linkage with the MDB, and features were registered in MDB. Bentley Map has linkage with the database on SQL-server. I copy feature property from MDB to SQL-server.
It's possible that you haven't copied all required data to your SQL Server database. A database linkage has two components: the MS Link and the Entity Number. The Entity Number is the ID of a table found in table MSCATALOG. MS Link identifies a row in the table having that ID. There's a more comprehensive explanation of database linkages.
For your project to work with SQL Server, the contents of MSCATALOG must be identical to that table in your Access database. Otherwise, when MicroStation or Bentley Map attempts to find the row identified by Entity Num:MS Link it won't find anything.
Regards, Jon Summers LA Solutions
Yep, like Jon said.
Make sure you have the mscatalog table copied across, exactly the same as in Access. The entity number allows Microstation/Bentley Map to find the correct table ( as defined in the mscatalog table entries) and the mslink finds the correct record in the table. Without both you will find nothing.
I agreed with you. While the MSlink and the Entity Number were not copied both to SQL I can't see nothing. But now MSCATALOG and another table are identical, and when i try to have feature property I see next:
It's mean that Bentley Map can find necessary table and row, but BM read just mslink, another column are empty.
Mira: But now MSCATALOG and another table are identical
What is the result of executing the following SQL statement (i) in your Access DB (ii) in your SQL Server DB?
SELECT tableName,entityNum FROM mscatalog ORDER BY tableName;
Is there a way you can send me one of the drawings and the access database to see if I can reproduce what you are seeing.
If it is small enough, you can send it via email, otherwise post it up on the FTP site ( ftp.bentley.com/pub/incoming) and let me know ( via email) what the file(s) are named.
Thanks !