Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: Rob Vleeschhouwer
  Where is Rob Vleeschhouwer?
 Leeuwarden
 Netherlands
 Rob Vleeschhouwer
 Tags
Subject: RE: select readonly.
Thread ID: 143288 Message ID: 143289 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Monday, August 27, 2007 2:05:23 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

Rob

There is a readwrite clause for select.

SELECT YourFieldList from YourTable where YourWhereClause into YourCursor ReadWrite

Regards
Tushar

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