Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Querying
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01059617
Message ID:
01059936
Views:
10
>How can I use this....
>
>Select * from Proyect ;
>where Type_P = m.Type_P ;
>and Number = m.Number ;
>Into cursor ResultSet
>
>to present the information in textboxes in the form. Instead of a report or a grid.?

Juan
1) Add a 'Fields' property to your form
2) Set the controlsource in your textboxes to be ThisForm.Fields.NameOfField, like in ThisForm.Fields.Type_P
3) Run select * from proyect bla blabla
4) SCATTER NAME ThisForm.Fields
That's it. If you want to save back, use "gather name Thisform.Fields" command.

HTH
Jaime

Let me see if I understand this...
Like this...?

Select * from Proyect ;
where Type_P = m.Type_P ;
and Number = m.Number ;
Into cursor ResultSet <--- "ResultSet" is a temporary table?
Scatter Name thisform.fields

just like this?
I have a lot of different text boxes... do i have to say...

im still not sure how to express the code... :(
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform