Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Arrange records
Message
 
 
To
14/03/2004 23:06:35
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00886053
Message ID:
00886198
Views:
15
This message has been marked as a message which has helped to the initial question of the thread.
Hi Ryan,

A cursor created by a query is read-only. In VFP7 and later you can add READWRITE clause to the SELECT to make the cursor updatable.
...
  INTO CURSOR Cur_item READWRITE
>Hi Sergey,
>
>thanks it works.
>
>But why this statement gives me readonly to the grid?
>column2(itmqty) cannot edit co'z of readonly.
>the grid,column,text are all enabled .t. and readonly .f.?
>
>        SELECT mytable.* ;
>	        FROM mytable ;
>	        JOIN SizeOrder ON SizeOrder.size = mytable.SIZE ;
>		 ORDER BY mytable.COLOR, SizeOrder.SortOrder INTO CURSOR Cur_item
>		
>		 Select Cur_item
>	       .grid1.recordsource = 'cur_item'
>	       .grid1.column1.controlsource = 'cur_item.item'
>	       .grid1.column2.controlsource = 'cur_item.itmqty'
>	       .grid1.column3.controlsource = 'cur_item.unitpr1'
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform