Hi Kieth, Not sure if this is related to synonyms, but I guess from version 9.1 view form doesnt support synonyms and you will have to convert them to actual database views.
Thanks, Vinod Gaidhani. On Mon, Dec 19, 2016 at 8:05 PM, Sinclair, Keith <[email protected]> wrote: > ** > > List, > > > > I am banging my head against the wall on this one as I am not finding out > any decent information. I cannot create a view form that links to an > external DB whereas the same view form in my 8.1.2 test system connects > without issue. > > > > I have gone through both systems and they seem to be an apples to apples > comparison. Both DB links are public database links. Both are accessible > and working inside SQL developer. Thoughts? > > > > 5165 Error > > Table fields must have at least one column. > > > > Table fields must have at least one column. See the section on Tables for > more information. > > > > 91.2 Running RedHat on Oracle 11g > > > > *Keith Sinclair* > > Remedy Development > > ShopperTrak Chicago, USA > > *O* 312.676.8289 > > [email protected] | shoppertrak.com > > *Retail Profitability, Improved.* > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
