Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Rob Vleeschhouwer
  Where is Rob Vleeschhouwer?
 Leeuwarden
 Netherlands
 Rob Vleeschhouwer
 Tags
Subject: select readonly.
Thread ID: 143288 Message ID: 143288 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Monday, August 27, 2007 1:59:30 PM         
   


Hello all,

How can I achieve that a select * where...... into cusor mycursor is NOT readonly.

The situation is as follows.

File1 && Customers
File2 && Orderlines

Relation based on cust_id

When I have to change an order I do not want to open the whole table Orderlines, but
only records with a cust_id that's the same as the customer, I want to put in a cursor.
But the cursor is allways readonly.

Is that the right technique or is there a better way.

Rob

ENTIRE THREAD

select readonly. Posted by Rob @ 8/27/2007 1:59:30 PM
RE: select readonly. Posted by tushar @ 8/27/2007 2:05:23 PM
RE: select readonly. Posted by Andy Kramek @ 8/27/2007 2:28:00 PM
RE: select readonly. Posted by Rob @ 8/30/2007 10:54:33 AM
RE: select readonly. Posted by Andy Kramek @ 8/30/2007 1:11:36 PM
RE: select readonly. Posted by Rob @ 9/3/2007 6:50:41 PM
RE: select readonly. Posted by Andy Kramek @ 9/3/2007 10:58:37 PM
RE: select readonly. Posted by Rob @ 9/4/2007 12:50:36 AM
RE: select readonly. Posted by Ken Murphy @ 9/4/2007 1:26:26 AM