Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid's column readonly based on another grid's value
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01505542
Message ID:
01505659
Views:
47
>>>I have a related problem.
>>>
>>>In my second grid I have currently the following
>>>
>>>WITH thisform.grdOperators 
>>>     .colEmail.DynamicCurrentControl = "iif(not EMPTY(csrOperators.Email),'chkEn','chkDis')"   
>>>     .colNetSend.DynamicCurrentControl = "iif(not EMPTY(csrOperators.NetSend),'chkEn','chkDis')"   
>>>     
>>>     .colPager.DynamicCurrentControl = "iif(.F.,'chkEn','chkDis')"   
>>>     .colSMS.DynamicCurrentControl = "iif(.F.,'chkEn','chkDis')"   
>>>     .colTwitter.DynamicCurrentControl = "iif(.F.,'chkEn','chkDis')"   
>>>ENDWITH
>>>
>>>However, csrOperators is not even used. The grid's column uses a combobox with RowSourceType = 3 and the RowSource =
>>>'select * from csrOperators into cursor cTemp'
>>>
>>>I want to enable / disable checkboxes based on the selected operator (the EMail, etc. fields are in the csrOperators and cTemp).
>>>
>>>Will it work adding (iiif (seek(GridAlias.op_Code, 'csrOperators','op_code') and not empty (...)
>>>
>>>e.g. do you think adding SEEK here will help?
>>
>>
>>Should work.
>
>Looks like I found a problem. LEN(Operator.nNetSend) returns 100 even though the field is empty. I thought LEN in VFP behaves the same as in SQL Server.
>
>UPDATE. Yes, after I added ALLTRIM it now works. Thanks again.

:o)
Sorry for not answering you, but I fall asleep immediately after my last answer :-)
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