Reorder P3D Properties - SQL Server Database

[rafaelavelar]

Hi,

Normally in project using SQLite Local Database when you add a new P3D Property, this property goes to the end of the P3D Line Group table and it won't change when you close and reopen the project.

I learned with @CarstenBeinecke that if you wanna change this order, you could using SQLite Expert Personal, open Piping.dcf file and reorder the PnPProperties table as you want.

I'm starting to use projects using SQL Server Database. When I add a new P3D Property, this property goes to the end of the P3D Line Group table but when I close and reopen the project the PnPProperties table reorganize using the following Index Key Columns (TableName - Ascending, PropertyName - Ascending) and I can't change this rules

I'm not able to change the alphabetical order so I can't control the order of my P3D Line Group table.

Somebody knows how to help me?

Best regards,

Rafael Avelar

[CarstenBeinecke]

Hi Rafael,

if I remember correctly you have to actually cut the records from the table and past them into excel, then reorder there and then paste them in the new order in the table. It doesn't help to order/reorder the properties in the table on SQL Server.

You can also use our PropertiesPalette as part of our PlantExpressTools. Just watch the first video from the following link:

https://documentation.auxalia.com/EN/PlantTools.html?pet_htu_proppalette_videos.htm