Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index not set?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01043460
Message ID:
01043465
Views:
8
VFP is confused between SEEK command and SEEK() function. I would recomend to use SEEK() function.
IF SEEK(ALLTRIM(thisform.combo1.Text), "a_arcadr", "cshipno")
BTW, GO TOP is unnecessary because SEEK always starts from the top.

>I keep getting an error telling me the table has no index set, but I thought by using the seek and setting the order to cshipno it wouldnt be a problem? There is probably a simple answert for this...TIA!!!
>SELECT a_arcadr
>GOTO top
>SEEK (ALLTRIM(thisform.combo1.Text)) ORDER cshipno
>IF FOUND()
>	
>	thisform.scompany.Value = company
>	thisform.saddress1.Value = saddress1
>	thisform.saddress2.Value = saddress2
>	thisform.scity.Value = scity
>	thisform.sstate.Value = sstate
>	thisform.szip.Value = szip
>ELSE
>	WAIT WINDOW "customer address not found"
>ENDIF
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform