>I have a uniqueindex made like FAI2005-000001. It is based on the year the record was input. When a new record is added I need the last unique id plus 1. My SQL statement I use is:
>
>Select faiuniqueid From fai_required Where Val(SubStr(faiuniqueid,4,4)) = Year(Date()) InTo Cursor myFAIlist
>
>This sql statement runs very slow on our older computers. Is there a way to do this different to make it faster?
Steven,
I assume your index expression is directly the field name (ie: value stored in index is directly FAI2005-000001).
Select faiuniqueid From fai_required Where faiuniqueid = 'FAI'+padl(year(date()),4) InTo Cursor myFAIlist
Should make it faster. Or even you don't need a select to get max. Set order to desc, seek to that value.
Cetin