Hi Guys,

   I have a table with an Invnumb field which is an Integer, and a Partnum field
which is a string.

   I need to create a descending index of the type str(invnumb,6)+partnum.

   None of the DBISAM tools allow me to do it.

   Is such an index permissable in DBISAM?
   
   If yes then I take I will have to create it programatically?

Regards & TIA,

Ian
   

--

Ian

Just use DBSys. Alter table and the Index tab. Depending on the version you'll be able to create a descending index or (with the later V4) specify which
fields are descending or ascending.

Roy

Roy Lambert wrote:

> Ian
>
> Just use DBSys. Alter table and the Index tab. Depending on the version
> you'll be able to create a descending index or (with the later V4) specify
> which fields are descending or ascending.
>
> Roy

Hi Roy,

   DBSys allows me to assemble an index which is invnumb,partnum descending but
when I try to save it, it falls over.  I suspect due to the mix of Integer &
character fields.

Regards

--

Ian

Just tried it and it's fine here. Which version of DBISAM? I'm on 4.25.

Roy Lambert wrote:

> Ian
>
> Just tried it and it's fine here. Which version of DBISAM? I'm on 4.25.

Yup.  4.25.  Strange.

--

Ian


Corrupted table?

Roy Lambert

Ian,

<< DBSys allows me to assemble an index which is invnumb,partnum descending
but when I try to save it, it falls over.  I suspect due to the mix of
Integer & character fields. >>

What do you mean by "falls over" ?  Are you getting an error message ?

--
Tim Young
Elevate Software
www.elevatesoft.com