Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid Basics
Message
 
 
To
29/06/2011 17:20:32
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01516758
Message ID:
01516772
Views:
50
>>>>When working with grid, you're working with the underlying cursor (the one from the RecordSource). So, if 3 records are populated, the 7 others probably have nothing in one of the key fields. You can use it as your criteria.
>>>
>>>Naomi:
>>>
>>>Thank a lot. As usual, you are lightning fast.
>>>
>>>1. Let's say that the underlying cursor is a table with 13 records. You're saying I should change the data directly in the table, not the grid. How do I know what record number to go to for each row?
>>>
>>>2. One of the columns is a checkbox. I added it to the column and deleted the text box. Why can't I see the checkbox at runtime?
>>
>>2. Set the column's sparse property to .f. Did you add the checkbox in design-time? If in run-time, don't forget to set its visible property to true.
>>
>>1. If you have a PK field in your table, the currently 'active' row is just one record in the cursor and you can identify it by the PK.
>
>1. The underlying table in my little test form is a table without any index.
>
>2. The checkbox is bound to a logical field in the table, yet when I try to click it, I get a datatype mismatch.
>
>3. The spec calls for a button on the form that says 'Select all'. I then need to loop thru all the records that are being displayed to change the underlying field to .t., no? So I'm not changing JUST the active record. So again - How do I know which records to go to?

2. If this is a logical field, make sure that the value of your checkbox is set to .f. (and not 1)

3. If you want to Select all records that have some values, then
replace LogicalField with .T. for SomeOtherField <> space(10) in GridCursor && Make sure the record is not completely empty
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform