Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index not set?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01043460
Message ID:
01043465
Vues:
7
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform