Re: [U2] ODBC - Not finding the MV fields.

2014-02-15 Thread Wols Lists
On 15/02/14 19:05, Chris Austin wrote: > I guessing could do all that.. OR have excel refresh the tables when u > connect... > > Maintaining separate tables just for ODBC is silly Some of us learnt the *hard* way that it's a GOOD idea to have separate dictionaries. HyperStar wasn't the most bug-

Re: [U2] ODBC - Not finding the MV fields.

2014-02-15 Thread Buss, Troy (Contractor, Logitek Systems)
-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Saturday, February 15, 2014 11:08 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC - Not finding the MV fields. We have a ton of I descriptors and it's quick when u set the option to refresh in e

Re: [U2] ODBC - Not finding the MV fields.

2014-02-15 Thread Chris Austin
We have a ton of I descriptors and it's quick when u set the option to refresh in excel.. How many I descriptors do u gave? > From: troy.b...@nordsonasymtek.com > To: u2-users@listserver.u2ug.org > Date: Sat, 15 Feb 2014 13:21:37 -0500 > Subject: Re: [U2] ODBC - Not finding the

Re: [U2] ODBC - Not finding the MV fields.

2014-02-15 Thread Chris Austin
> -Troy > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman > Sent: Friday, February 14, 2014 12:32 PM > To: 'U2 Users List' > Subject: Re: [U2] ODBC - Not finding the M

Re: [U2] ODBC - Not finding the MV fields.

2014-02-15 Thread Buss, Troy (Contractor, Logitek Systems)
a few moments to flag the field and subsequently test with MS access. -Troy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, February 14, 2014 12:32 PM To: 'U2 Users List' Subject

Re: [U2] ODBC - Not finding the MV fields.

2014-02-14 Thread Bill Brutzman
Subject: Re: [U2] ODBC - Not finding the MV fields. 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

Re: [U2] ODBC - Not finding the MV fields.

2014-02-14 Thread Chris Austin
-users@listserver.u2ug.org > 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 b

Re: [U2] ODBC - Not finding the MV fields.

2014-02-14 Thread Bill Brutzman
PM To: u2-users@listserver.u2ug.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)

Re: [U2] ODBC - Not finding the MV fields.

2014-02-14 Thread Chris Austin
nfor-mation Cache is not updated by the operation. Update the cache by running HS.UPDATE.FILEINFO in the UniVerse account you are accessing on the server system > From: cjausti...@hotmail.com > To: u2-users@listserver.u2ug.org > Date: Thu, 13 Feb 2014 15:04:09 -0600 > Subject: [U2]

[U2] ODBC - Not finding the MV fields.

2014-02-13 Thread Chris Austin
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