Bill, Not sure why you would do those 6 steps, when running HS.UPDATE.FILEINFO from a command line or program will do the same thing (reset the cache w the updated tables).
I like to limit the amount of dictionary entries I have. Chris > From: bi...@hkmetalcraft.com > To: email@example.com > Date: Fri, 14 Feb 2014 12:37:29 -0500 > Subject: Re: [U2] ODBC - Not finding the MV fields. > > Chris: > > 1. For things here, I usually create a new DICTionary... copy the old DICT > to the new DICT... and strip out NAME and other DICT columns not needed by > ODBC... in the new DICT. > 2. A @SELECT of type PH is needed where the Phrase needs to specify the > chosen fields... in the new DICT > 3. LOGTO HS.ADMIN. > 4. Launch HS.ADMIN. > 5. Run 6... Update File Info Cache in an account. > 6. I hope that this helps. > > --Bill > > > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin > Sent: Thursday, February 13, 2014 4:04 PM > To: firstname.lastname@example.org > Subject: [U2] ODBC - Not finding the MV fields. > > We're running UniVerse 11.x and we've had ODBC setup for a while but > recently started to use it more. The single-value fields work just fine, but > on some of the Multi-Value fields (only certain tables) we can get the ODCB > to work in excel by manually entering the SQL command but they don't show in > Microsoft Query. > > So the issue is that we don't see it in the Microsoft Query window, or even > in Access (for certain tables). Is there anyway to "debug" why the MV on > some tables work, but others don't? Is there a way to list the tables that > ODBC recognizes? > > I tried using Dr. DeeBee and it wasn't much help since I didn't get a log > after running it. > > Any help is appreciated, thanks. > > Chris > > > > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users