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?
 Stefan Wuebbe
 To: ashish mehta
  Where is ashish mehta?
 ashish mehta
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
> VALID1.MARKS,VALID2.marks FROM valid1 JOIN valid2 ON VALID1.roll_no=VALID2.roll_no;
> .and. valid1.marks<>valid2.marks ;
> 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?


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.



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