Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Compound Index question. |
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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |