Progress 11.5.1 on Win7.
I've just done a diff on some code I've edited in the AppBuilder and noticed that PDSOE seems to be stripping the DBName from AppBuilder code. I have the setting on to prefix table names with the DB name. I'll show a couple of examples of what I mean.
/* Internal Tables (found by Frame, Query & Browse Queries) */ &Scoped-define INTERNAL-TABLES lb-StandardDiscount MeterSiteReference ~ ObjectStatus ICMAS.StandardDiscount tt-TenderExclusion
/* Internal Tables (found by Frame, Query & Browse Queries) */ &Scoped-define INTERNAL-TABLES lb-StandardDiscount MeterSiteReference ~ ObjectStatus StandardDiscount tt-TenderExclusion
&Scoped-define TABLES-IN-QUERY-bro-msr-ele ICMAS.MeterSiteReference ~ ICMAS.ObjectStatus &Scoped-define FIRST-TABLE-IN-QUERY-bro-msr-ele ICMAS.MeterSiteReference &Scoped-define SECOND-TABLE-IN-QUERY-bro-msr-ele ICMAS.ObjectStatus
&Scoped-define TABLES-IN-QUERY-bro-msr-ele MeterSiteReference ObjectStatus &Scoped-define FIRST-TABLE-IN-QUERY-bro-msr-ele MeterSiteReference &Scoped-define SECOND-TABLE-IN-QUERY-bro-msr-ele ObjectStatus
How can I get PDSOE to stop doing that?
Appbuilder code will be generated by the appbuilder whenever the designer is open, not only on save, but also when switching between source and design without saving. The code generation is complex and PDSOE settings are not considered as code generation is done by Appbuilder. The table name prefixed will be retained only in code which user writes like in triggers if you write code and prefix table name. This is not changed by Appbuilder. However appbuilder generated code will not honor this.
Open Project Properties and navigate to the OpenEdge -> AppBuilder node and make sure the "Qualify database fields with database name" option is checked.
This should cause the database name to be added to the field names next time the code is generated. This option controls the code that is generated by the AppBuilder and not what is inserted by code assist.
It's a project setting? No wonder I couldn't find it. Thank you Håvard.