Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Tue, Jul 31 2007 7:39 AM	Permanent 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 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Ian You create a field holding the data. DBISAM doesn't support calculated indices Roy Lambert
Tue, Jul 31 2007 8:46 AM	Permanent 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 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. 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