Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid
Message
From
06/03/2006 22:58:57
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Re: Grid
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01101819
Message ID:
01101934
Views:
8
hi,
thank you.

>>1.but
>> I see all fields i have at my table i need to see only the 3 field i choise.
>
>
>Select * from trans1 into cursor csrmyCursor readwrite where .F.
>SELECT csrMyCursor
>With thisform.Grid1
>  .RecordSource = "csrMyCursor"
>  .ColumnCount = 3  && Add this line
>  .Column1.ControlSource = "csrMyCursor.bookno"
>  .Column2.ControlSource = "csrMyCursor.sticket"
>  .Column3.ControlSource = "csrMyCursor.eticket"
>  append blank
>  .Refresh()
>ENDWITH
>
>
>>2.I need to append new record at the last field at myGRID if this field not empty.
>
>Thisform.Grid1.AllowAddNew = .T.
>
>and then you will need to use the Afterrowcolchange event and in there figure out which row you were on and which column you were in so you can determine if you need to append blank and Thisform.grid1.refresh() or not. It is not pretty, easier to teach your users to press down arrow to add a record then you only need the AllowAddNew property set.
Previous
Reply
Map
View

Click here to load this message in the networking platform