To populate updated Revision field in OpenPlant Isometrics Manager
In OpenPlant Isometrics Manager, isometrics output drawing title block contains revision field but it does not get updated. Below steps will aid user to update the Revision using DB Query inside Textnode.txt file present under style folder. As a prerequisite, user should be aware of SQL and able to create new file and must be knowing version compatibility and relevant terms like creating table and assigning datatype etc.Below steps explained on 32 bit machine.
# The database DSN myDsn = Driver={Microsoft Access Driver (*.mdb)};Dbq=$(IE_CONF)revision.mdb # this creates a table in the database and puts a unique index on the filename field @a0 = DBQUERY ($(myDsn), Create Table iso_revisions (filename varchar(255), revision int)) @a1 = DBQUERY ($(myDsn), Create UNIQUE index index1 on iso_revisions (filename))
# This inserts a row for the filename if not yet there and initializes the revision to 1 @a2 = DBQUERY ($(myDsn), Insert into iso_revisions (filename, revision) VALUES ('$(NAME)', 1))
# this gets the current revision number for the table @Rev = DBQUERY ($(myDsn), Select revision from iso_revisions where filename = '$(NAME)')
# this increments the revision table number (for the next time) @a3 = DBQUERY ($(myDsn), Update iso_revisions set revision = $(rev)+1 where filename = '$(NAME)') REV_MAIN=$(Rev)
Adding Data from The Process Table to Isometric Backing Sheet, Drawing Frame, Seed File Applies To Product(s): OpenPlant Isometrics Manager Version(s): 08.11.09.XXX (SS5) | 08.11.11.XX (SS6) Environment: Windows 7/8.1/10 (64 bit) Area: Settings/Attributes… Last edited over 5 years ago in OpenPlant | AutoPLANT > OpenPlant | AutoPLANT Wiki
DBQuery : usage, logging, debugging Applies To Product(s): OpenPlant Isometrics Manager Version(s): N\A Environment: N\A Area: Settings/Attributes Subarea: DBQuery Original Author: Artiom… Last edited over 5 years ago in OpenPlant | AutoPLANT > OpenPlant | AutoPLANT Wiki
Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this Comments or Corrections?" section. THANK YOU!