Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rewrite code
Message
 
To
21/06/2006 06:02:45
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01130156
Message ID:
01130460
Views:
17
Again I don't understand.
In List1 you have Q11A what you want the LOCATE to be?


>sorry,
>i mean if thisform.list1.value have Q11,Q11A,Q2,Q2B,
>and flag1 have q1,q1a,q11a,q2b...etc characters type from dnc.dbf,
>thanks.
>
>
>>Where?
>>If you have [Q11A] in thisform.text42.Value
>>lnFor = VAL(SUBSTR(thisform.text42.Value,2)) && this will be equal to 11
>>
>>
>>>hi,
>>>
>>>any idea if i have q11 and q11A(not the same flag1),
>>>
>>>LOCAL lnFor
>>>thisform.text42.Value = thisform.list1.value
>>>CLOSE all
>>>SELECT 0
>>>USE dnc
>>>lnFor                   = VAL(SUBSTR(thisform.text42.Value,2))
>>>LOCATE FOR flag1        = m.lnFor
>>>ThisForm.Label1.Caption = q1
>>>ThisForm.Label2.Caption = q11
>>>CLOSE all
>>>USE answers
>>>
>>>thanks.
>>>>
>>>>LOCAL lnFor
>>>>thisform.text42.Value = thisform.list1.value
>>>>CLOSE all
>>>>SELECT 0
>>>>USE dnc
>>>>lnFor                   = VAL(SUBSTR(thisform.text42.Value,2))
>>>>LOCATE FOR flag1        = m.lnFor
>>>>ThisForm.Label1.Caption = q1
>>>>ThisForm.Label2.Caption = q11
>>>>CLOSE all
>>>>USE answers
>>>>
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