Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Searching a table and jumping to the record
Message
From
01/06/2005 05:54:23
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01018885
Message ID:
01018903
Views:
11
You must make sure that retval is either a unique identifier, or the record number. Then you use either Locate for yourfield=yourRetval (or SEEK or any of the other similar functions), or Goto yourRetval if you use record number. Myself I never use record number, except for cursors.

>Thankyou Tore
>
>I have now created the following syntax in the keypress event on the grid:
>
>
>IF nKeyCode = 13 && Enter key
>thisform.retval = curmatch.artikey
>THISFORM.Release()
>ENDIF
>
>
>In addition I have created a property on the form named retval and in the unload event of the form I have
>
>
>return thisform.retval
>
>
>How can I use this property value to find the record in my main table?
Previous
Reply
Map
View

Click here to load this message in the networking platform