Subject | IBO4 |
---|---|
Author | hans@hoogstraat.ca |
Post date | 2001-09-20T19:05:43Z |
Hello
Just verifying
In IBO4 if I have a table say:
PRODUCTS:
UNIQUENUM INTEGER NOT NULL
PRODNAME VARCHAR(20) NOT NULL
PRIMARY KEY (UNIQUENUM)
With
CREATE ASC INDEX PRODNAME_ASC ON PRODUCTS (PROD_NAME)
CREATE DESC INDEX PRODNAME_DESC ON PRODUCTS (PROD_NAME)
An Incremental Lookup on PROD_NAME should 'fly' if I set
the TIBOQUERY Orderlink to PROD_NAME=ITEM=1;POS=0 ?
and trying to find out the meaning of ITEM
Best Regards
Hans
Just verifying
In IBO4 if I have a table say:
PRODUCTS:
UNIQUENUM INTEGER NOT NULL
PRODNAME VARCHAR(20) NOT NULL
PRIMARY KEY (UNIQUENUM)
With
CREATE ASC INDEX PRODNAME_ASC ON PRODUCTS (PROD_NAME)
CREATE DESC INDEX PRODNAME_DESC ON PRODUCTS (PROD_NAME)
An Incremental Lookup on PROD_NAME should 'fly' if I set
the TIBOQUERY Orderlink to PROD_NAME=ITEM=1;POS=0 ?
and trying to find out the meaning of ITEM
Best Regards
Hans