Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Compound Index question.
Tue, Jul 31 2007 7:39 AMPermanent Link

"Ian Branch"
How do I create the equivalent of this INDEX in DBISAM?

str(INVNUMB,6)+PARTNUM+iif(ONBO==.T.,"T","F")

Regards & TIA,

Ian

--
Tue, Jul 31 2007 8:08 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Ian


You create a field holding the data. DBISAM doesn't support calculated indices

Roy Lambert
Tue, Jul 31 2007 8:46 AMPermanent Link

"Robert"

"Ian Branch" <branch@sitathome.net> wrote in message
news:B00BBDAD-8E57-4E39-A88D-D263AD4D023B@news.elevatesoft.com...
> How do I create the equivalent of this INDEX in DBISAM?
>
> str(INVNUMB,6)+PARTNUM+iif(ONBO==.T.,"T","F")
>

If you must have a single field, then you have to build it yourself, as Roy
indicated (the BeforePost is a good place to do it). Of course, you can
define an index comprised of multiple fields, just that you can't access it
as a single field.

Robert


Tue, Jul 31 2007 8:40 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Ian,

<< How do I create the equivalent of this INDEX in DBISAM? >>

Just create it as an index on the INVNUMB, PARTNUM, and ONBO columns.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image