table has no index order set ????

GaryWilsonCPA · Jan 17, 2002

I am trying to do a search and I get the error "table has no index order set" I have set my clients file with several fields that are indexed.

I am using a textbox on a form with this code in the keypress area of the text box

LPARAMETERS nKeyCode, nShiftAltCtrl

* SaveAlias() Saves current ALIAS()

lcData = ALLT(THIS.Value)+ CHR(nkeyCode)
Any ideas?

SELE clients && Select Alias()
SET NEAR ON
SEEK UPPE(lcData)
SET NEAR OFF

RELE lcData

THISFORM.list1.Refresh()

* RestAlias() Restore old ALIAS()

DEDMOD · Jan 17, 2002

Look in the help under 'SET ORDER' for details on what you should do. In a lot of cases you don't have to have an order set to use a table, but if you're doing a SEEK or a couple of other things, you do. I have to admit it's one of the things which always confuses me too, and I have to look it up every time I run into that error.

Dave Dardinger

weedz · Jan 18, 2002

SEEK can only be used if an index is used. It will search according to the index.
Use LOCATE FOR <expression> if you do not wish to create an index.

HTH,

Weedz (Wietze Veld)
My private project:

http://www.crowncap.demon.nl\info\crwnbase

Download the CrownBase source code !!

marsh · Jan 18, 2002

If the seek is on an index, but the table is currently not ordered, but in different order, use the full seek syntax:

Seek(SeekFor, Table, Index)

so that if your index is called MyIndex, the call would be

=Seek(UPPE(lcData), "Clients", "MyIndex')

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

table has no index order set ????

GaryWilsonCPA

Technical User

DEDMOD

Programmer

weedz

Programmer

marsh

Programmer

Similar threads

Part and Inventory Search

Sponsor