RE: [U2] UD: Indexes

2008-06-13 Thread Colin Alfke
Bill; So when somebody updates the address book data the next person to login rebuilds the indices on the ARTMASTER file??? If so, then that's likely the problem. UniData doesn't like it when a file is updated while the index is being built: HELP BUILD.INDEX (Windows 7.1.6) The ECL BUILD.INDEX

RE: [U2] UD: Indexes

2008-06-12 Thread Bill Haskett
Behalf Of Kevin King >Sent: Thursday, June 12, 2008 9:41 PM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] UD: Indexes > >What exactly are these subroutines doing? > >On Thu, Jun 12, 2008 at 6:51 PM, Bill Haskett <[EMAIL PROTECTED]> >wrote: > >> As a follow up

RE: [U2] UD: Indexes

2008-06-12 Thread Bill Haskett
AIL PROTECTED] On Behalf Of Colin Alfke >Sent: Thursday, June 12, 2008 9:31 PM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] UD: Indexes > >Bill; > >We haven't had trouble since an early version of version 6 had an "overly >optimized" version of udtsort.

Re: [U2] UD: Indexes

2008-06-12 Thread Kevin King
What exactly are these subroutines doing? On Thu, Jun 12, 2008 at 6:51 PM, Bill Haskett <[EMAIL PROTECTED]> wrote: > As a follow up, here's an index that was corrupted earlier: > > 2 Dev (0)-> LIST-INDEX ARTMASTER > Alternate Key Index Details for File ARTMASTER Page 1 > > File

RE: [U2] UD: Indexes

2008-06-12 Thread Colin Alfke
Bill; We haven't had trouble since an early version of version 6 had an "overly optimized" version of udtsort. Are any of those subroutines returning data from a remote file? UniData doesn't have a link to the remote file to know when it's updated so the index won't be updated. Are they supposed

RE: [U2] UD: Indexes

2008-06-12 Thread Bill Haskett
As a follow up, here's an index that was corrupted earlier: 2 Dev (0)-> LIST-INDEX ARTMASTER Alternate Key Index Details for File ARTMASTER Page 1 File.. ARTMASTER Alternate key length.. 45 Node/Block size... 4K OV blocks. 1 (0 in use, 0 overflowed)

RE: {Blocked Content} RE: [U2] UD indexes and UniQuery - redux

2007-08-31 Thread Bill Haskett
ON and SORT.TYPE is non-zero. We should figure out some kind of resolution. Thanks, Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >[EMAIL PROTECTED] >Sent: Thursday, August 30, 2007 8:51 PM >To: u2-users@listserver.u2ug.org &g

{Blocked Content} RE: [U2] UD indexes and UniQuery - redux

2007-08-30 Thread colin.alfke
Warning: This message has had one or more attachments removed Warning: (not named). Warning: Please read the "AngelicHost-Attachment-Warning.txt" attachment(s) for more information. Bill; We use them all the time. They make a huge difference (especially on the older, slower systems). I don't kno

RE: [U2] UD Indexes

2006-04-12 Thread Bill Haskett
Simon: Thanks very much. I'll pursue this immediately. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Simon Lewington > Sent: Wednesday, April 12, 2006 1:35 AM > To: u2-users@listserver.u2ug.org > Su

Re: [U2] UD Indexes

2006-04-12 Thread Simon Lewington
"Bill Haskett" ... > I'm running UD v7.1 and got an error message from within a BASIC program > like: > > In E:\DataTrust\DTA\BP\BP\_TRREC at line 1161 "-" is not an indexed/legal > field. > > ..caused by the BASIC statement: > > SETINDEX NAME.KEY, A.CODE ON ARTDESC ... > Am I correct in assuming