Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid Basics
Message
From
29/06/2011 17:29:33
 
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:
01516773
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
I only want to cange the records that are currently being displayed on the grid, so it's a subset of the records in the cursor/table. How do I know what records are being displayed?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform