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


--

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

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

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

--

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