PdcOverview.GetMaterialPrognosis

Declaration

GetMaterialPrognosis() as string

Description

Generates the calculationoverview "Material Prognosis" and returns the created tablename.

Notes

Before generation of the overview, you can change all overview settings by writing them directly in ConfigDB.

Code example

Dim aView
Dim aTableName
dim aQuery

set aView = pdc.overview
aTableName = aview.GetMaterialPrognosis

msgbox aTableName

set Qry = pdc.Database.OpenQuery(1) '1 = database
Qry.SQL = "SELECT * FROM " & aTableName
if Qry.Execute then
  if Qry.RecordCount > 0 then
     msgbox Qry.RecordCount
   else
     msgbox "no records"
   end if
else
   msgbox pdc.LastError
end if

Availability

Available since October 2019 (From version 5.5)