Keith, If logged into the Remedy DB and issuing the same query, I assume you see the values expected. What are the types of columns available in the remote db and what are their sizes?
I know that between 8.x and 9.x Remedy changed from C to Java...which means the criteria may have changed a bit as well, but shouldn't have changed significantly... On Mon, Dec 19, 2016 at 1: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 <(312)%20676-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"
