Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: jared fernandez
  Where is jared fernandez?
 Caloocan City
 Philippines
 jared fernandez
 Tags
Subject: Record No. 1
Thread ID: 189282 Message ID: 189282 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, August 14, 2008 9:05:35 AM         
   


I got a checkbox in a grid. What I want is to update the items with checked checkbox. But whenever I do it, record number 1 is also changed even it is not included (its checkbox is false)

Here's my code :

select mygridcursor 
scan				
update table ;
	set remarks1 = remarks ;							
	where table.prno = thisform.txtprno.value;								
	and table.item_no = mygridcursor.item_no 
	and mygridcursor.checkitem = .t.
endscan	
=tableupdate(.t., .t., "table")


Thanks in advance.

"The hope that changed a second chance I

ENTIRE THREAD

Record No. 1 Posted by jared fernandez @ 8/14/2008 9:05:35 AM
RE: Record No. 1 Posted by Stefan Wuebbe @ 8/14/2008 9:16:06 AM
RE: Record No. 1 Posted by jared fernandez @ 8/14/2008 9:19:27 AM
RE: Record No. 1 Posted by Stefan Wuebbe @ 8/14/2008 9:22:22 AM
RE: Record No. 1 Posted by jared fernandez @ 8/14/2008 9:30:47 AM