>I have a SQL cursor that is ordered by one of the fields. Later in the code I want to use the seek command on this cursor which requires an index. If I Index On the cursor I loose my Order By integrity. Please Help.
Isn't it SELECT INTO CURSOR a read only? You can't create index into it. SELECT INTO DBF, yes. CREATE CURSOR will also do.
=SEEK(cusercode,'tablename','indexhere')
Above will do the seeking without changing the Order set. Look into INDEXSEEK() also.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."