Losing DB Prefix in AppBuilder code

Posted by James Palmer on 15-Oct-2015 04:08

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. 

Before:

/* Internal Tables (found by Frame, Query & Browse Queries)             */
&Scoped-define INTERNAL-TABLES lb-StandardDiscount MeterSiteReference ~
ObjectStatus ICMAS.StandardDiscount tt-TenderExclusion

After: 
/* Internal Tables (found by Frame, Query & Browse Queries)             */
&Scoped-define INTERNAL-TABLES lb-StandardDiscount MeterSiteReference ~
ObjectStatus StandardDiscount tt-TenderExclusion

Before: 
&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

After: 
&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?

OpenEdge Development - Forum

All Replies

Posted by Swathi Yellavaram on 15-Oct-2015 09:57

Hi James,

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.    

Thanks,

Swathi.

Posted by Håvard Danielsen on 15-Oct-2015 11:34

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.  

Posted by James Palmer on 16-Oct-2015 04:49

It's a project setting? No wonder I couldn't find it. Thank you Håvard.

This thread is closed