Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Seek() function
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00814877
Message ID:
00814885
Views:
11
>Don't rely on default value but check what setting you actualy have
? SET("NEAR")
>
>>I have a table indexed on an integer field in the "Key" tag with these values:
>>702065
>>702066
>>702067
>>702068
>>702069
>>etc....
>>
>>The record with the value 702066 in deleted and i Set Deleted On in my program.
>>If i write (also in Command Window)
>>
>>Messagebox(Seek(702066,"MyTable","Key"))
>>
>>It returns the .F. value but the record pointer is not positioned to the end of MyTable (Eof), but on the record after that deleted with the value i searched (702067).
>>
>>In the fox Guide i read:
>>"If a match is found, SEEK( ) returns true (.T.), and the record pointer moves to the matching record. If no match is found, SEEK( ) returns false (.F.) and the record pointer moves to the end of the file."
>>
>>I have no settings on SET NEAR and the default value must be "OFF"
>>
>>Where is the error.

With the debug the Sys(2001,"NEAR") return OFF
In my program i have:

If Seek( nKey, "MyTable1", "KEY")
nNumero = Val(PrimaNota->NUMERO)
If Seek(Pagate->K_PAG, "Giornale", "PNOTA")
Set Order To PNOTA In Giornale
DO While !Eof("Giornale") And Giornale->K_PNOTA = Pagate->K_PAG
Delete In Giornale
Skip In Giornale
EndDo
Set Order To (cOrder1) In Giornale
EndIf
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform