Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp50 - Select SQL
Message
From
06/03/1997 11:19:27
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00022936
Message ID:
00023139
Views:
40
>>>>I have perform a search using...
>>>>select *;
>>>>from datafile;
>>>>where lastname=search_name;
>>>>into cursor mycursor
>>>>
>>>>Now I want to user to pick the name he wants
>>>>in mycursor from a grid on a form.
>>>>How do I display the picked record in the datafile?
>>>
>>>First let the user pick the record then do the following :
>>>lcLastname = thisform.grid1.columnLastName.text1.value
>>>select *;
>>>from datafile;
>>>where lastname=?lcLastName;
>>>into cursor mycursor
>>
>>Hi Nabil
>>Thanks for your answer. I would like my search results displayed
>>on my form instead of in a browse type window. Can you help?
>>
>>Rob
>
>if you don't give it a destination (into cursor, table, etc.) it will put in a browse window...

i gave it a destination of..
INTO cursor anycursor
then..
SELECT anycursor

I would think that the cursor would use my form to display the
results. I would like to go back to the form I left before I
performed the SELECT statement using the results form the cursor.
any ideas?

rob
Robert Keith
Independent Developer
San Antonio, Texas
E-mail address:
rebelrob1@yahoo.com
Previous
Reply
Map
View

Click here to load this message in the networking platform