Hi,Does anyone know how the Update-PWSQL command works?I am trying to modify a table in the environment and it is impossible for me.
I can not find any information about that command.
Thank you very much
Traditionally the API has not allowed any SQL statement other than SELECT. There are other functions(commands) for modifying attributes (environment tables).
This cmdlet is not available for general use even though it is delivered.
My apologies, I forgot that this Cmdlet isn't for general use.
As for options, well there's always the ProjectWise SDK! You could call aaApi_ExecuteSqlStatement() using the ProjectWise SDK. The restrictions and limitations remain the same of course.
Dan WilliamsSolution ConsultantBentley Systems, IncorporatedPortland, OR, USA (Pacific Time UTC-08:00)
The SQL Server powershell module can give you access to the projectwise database tables, as Dan points out this is very dangerous. I only use the module to work with non-projectwise databases i have for admin tasks.