Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!cwjcc!ukma!xanth!mcnc!ecsvax!uncmed!earl!danielg
From: danielg@earl.med.unc.edu (Daniel Gene Sinclair)
Newsgroups: comp.databases
Subject: Re: dBASE III+ bug?
Message-ID: <407@uncmed.med.unc.edu>
Date: 16 Mar 89 16:11:02 GMT
References: <6056@bsu-cs.UUCP> <21458@agate.BERKELEY.EDU>
Sender: news@uncmed.med.unc.edu
Reply-To: danielg@uncmed.med.unc.edu (Daniel Gene Sinclair)
Distribution: na
Organization: UNC-CH School of Medicine
Lines: 36

>#*Here is a question for anyone out there more knowledgeable than I about
>#*dBASE.  I am doing an application involving several tables (.DBF files)
>#*dBase...
>#*I then index on
>#*             	request_no+str(item_no)

etc... etc... 

  [and the idexes are not updated properly when I append blank]
  
Then another guy writes...


>Check your manual on this, but I suspect you may be having a
>problem with STR defaults because you don't specify the length
>or number of decimal points of your output string, such
>as STR(item_no,5,0). So if you expect to get all digits, it's
>possible that there are spaces and periods embedded which
>interfere with indexing as you intend.
>
>Steve Goldfield

I am only a novice user but here's some suggestions.  I think the Steve is
right.  With numeric feilds, if you don't specify the string length,
dbase will give it a default length of 13 (no matter what the size of the
feild).  You can try the above suggestion, or maybe

    index on request_no+LTRIM(str(item_no3,1))

or the likes.  Later!


 Disclaimer: My opinion means | 'If you only knew how much I was holding
       nothing, but His means |  back, you would commend me'
       everything.            |      - Charles Spurgeon, 19th century 
 danielg@uncmed.med.unc.edu   |        evangelist (on humor in preaching)