Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Order
Message
 
 
To
08/01/2010 10:55:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01442768
Message ID:
01442778
Views:
57
You have to specify which index to use for seek. The best way is to use SEEK() function
IF SEEK(addition.name, "addition", "IndexTagToUseForSeek") 
>	USE ftab                   &&added by me
>*	SELECT ftab 
>	
>	USE addition              
>	SELECT addition             
>	SEEK addition.name  &&check for name 1st
>SCAN &&added my me
>	IF FOUND()
>	THISFORM.UpdateResultsWindow('error name already entered')
>	ELSE
>	THISFORM.continue
>	ENDIF
>	*SELECT addition
>ENDSCAN
>
>IT points at the Seek line
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform