Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query HELP how to present unique result in textboxes in
Message
From
19/10/2005 10:41:38
 
 
To
19/10/2005 10:23:13
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01060041
Message ID:
01060274
Views:
16
Juan,
Field1, Field2...FieldX are exemplary field names, you must replace them with actual field names from the cursor (or table Proyecto). Also I see I have a typo thisfirm must be thisform.
Try:
Select * from proyecto ;
      where tipomed = m.type_p and numero = m.numero ;
Into cursor ResultSet
BROWSE NORMAL
thisform.text1.Value = EVALUATE("ResultSet."+Fields(1,"ResultSet"))
>""If you just want to store the values of the fields in textboxes:
>
>Select * from proyecto ;
> where tipomed = m.type_p and numero = m.numero ;
>Into cursor ResultSet
>
>thisfirm.text1.Value = ResultSet.Field1
>thisfirm.text2.Value = ResultSet.Field2
>etc.
>Is that what you want?""
>
>well...
>
>when i use I get this error:
>
>Variable 'FIELD1' is not found
>Variable 'FIELD2' is not found
>Alias 'RESULTSET' is not found
>
>:(
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform