Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding a Record from a Cursor
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Finding a Record from a Cursor
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01035011
Message ID:
01035011
Views:
51
I have a form which allows the user to search a Table named Articles. The results are displayed in a grid which is bound to a cursor named mycursor. When the user selects a record from the grid and subsequently press enter I want to store the value of my artikey field in mycursor and use that to to find the record on my main form as some of the fields are bound to the same table named Articles. In the keypress event of mycursor I have:
IF nKeyCode = 13 && Enter key
thisform.retval = mycursor.artikey
THISFORM.Release()
ENDIF
When this form is release all I know is that thisform.retval=mycursor.artikey. My main form is bound to the Articles Table. Therefore how do I use the contents of thisform.retval to find the record in Articles so that my main form which is bound to the Articles Table shows the correct record to the user?

Many THanks
Neil Lewis
IT R&D Manager
Velmore Ltd
Next
Reply
Map
View

Click here to load this message in the networking platform