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: [email protected]
[mailto:[email protected]] On Behalf Of Chris Austin
Sent: Thursday, February 13, 2014 4:04 PM
To: [email protected]
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
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users

_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users