Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 5 of 5 total |
Compound Index |
Tue, Sep 12 2006 12:29 AM | Permanent Link |
"Ian Branch" | Hi Guys,
How do I create the following index in SQL?? str(invoicenumb,6,0)+partnum+iif(onbo=True,'T','F') Or can't I. Regards & TIA, Ian -- |
Tue, Sep 12 2006 2:56 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ian
DBISAM doesn't handle calculated indices so the simple answer is you can't. However, what you can do is create a compound index using all three fields eg CREATE INDEX IF NOT EXISTS "Career" ON "C2C" (_fkContacts, _Left DESC); Roy Lambert |
Tue, Sep 12 2006 4:06 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ian,
<< How do I create the following index in SQL?? >> You can't in DBISAM. You can do so (or I should say, you will be able to) in ElevateDB, however, via generated columns. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Sep 12 2006 7:28 PM | Permanent Link |
"Ian Branch" | Tim Young [Elevate Software] wrote:
> Ian, > > << How do I create the following index in SQL?? >> > > You can't in DBISAM. You can do so (or I should say, you will be able to) in > ElevateDB, however, via generated columns. Hi Tim, Thanks for that. Once again you offer a teaser for EDB. Regards, Ian -- |
Wed, Sep 13 2006 9:04 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ian,
<< Thanks for that. Once again you offer a teaser for EDB. >> Sorry, just trying to point out that help is on the horizon. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |