Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 To: ashish mehta
  Where is ashish mehta?
 bhopal
 India
 ashish mehta
 Tags
Subject: RE: update cursor
Thread ID: 288926 Message ID: 288929 # Views: 48 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Sunday, December 26, 2010 9:11:14 PM         
   


> hello,
> statement is
> SELECT VALID1.ENV_CODE,VALID1.PAGENO,VALID1.SUB_CODE,VALID1.TYPE,VALID1.PAPER,VALID1.ROLL_NO;,
> VALID1.MARKS,VALID2.marks FROM valid1 JOIN valid2 ON VALID1.roll_no=VALID2.roll_no;
> .and. valid1.marks<>valid2.marks ;
> INTO CURSOR Q1 READWRITE
> Thisform.pageframe1.page4.Grid3.RecordSource="q1"
>
> problem is, i change in marks value in grid3,i want to update table (valid1 or valid2)
> also, how can i do this?

Hi,

You can use a VFP View or CursorAdapter (instead of the "Into Cursor" cursor that you are currently using).
Both, Views as well as CursorAdpaters, can be made updatable easily, for instance via "Send Updates" option in the View Designer, if you want to use that one.



hth
-Stefan

ENTIRE THREAD

update cursor Posted by ashish mehta @ 12/26/2010 7:39:10 PM
RE: update cursor Posted by Stefan Wuebbe @ 12/26/2010 9:11:14 PM
RE: update cursor Posted by ashish mehta @ 12/27/2010 8:07:29 AM
RE: update cursor Posted by Koen Piller @ 12/26/2010 10:54:32 PM
RE: update cursor Posted by ashish mehta @ 12/27/2010 8:08:42 AM