Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
EDIT SQL results
Message
From
22/10/2000 17:22:12
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
 
To
22/10/2000 16:55:12
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00432623
Message ID:
00432670
Views:
20
Bob,

Absolutely right if you are only using one table and not aggregating anything.

I guess I use multiple tables so often that I forget that one.


>I think you would need to do:
>
>SELECT ... INTO CURSOR MyCursor NOFILTER
>USE (dbf(MyCursor)) SHARED AGAIN IN 0 ALIAS MyWritableCursor
>
>BOb
>
>
>
>>Mohammed,
>>
>>The way to make a cursor writable is
>>SELECT ... INTO CURSOR MyCursor
>>USE MyCursor SHARED AGAIN IN 0 ALIAS MyWritableCursor
but as the others have said, this is not really what you want to do.
>>
>>In VFP7 there will be a READWRITE clause in the SELECT statement which will automatically make the resulting cursor writable.
>>
>>
>>
>>>Hi, All
>>>
>>>I am developing my first application under visual foxpro 6.0. I usually use clarion under dos. I made a grid control to display a result of SELECT command it works fine. but, it does not allow me to edit any field in the grid control . I made sure that the read only is off and I went all over the step again and again but I could not know what's wrong. can anybody help me to edit to the table directly from the grid control ?
>>>
>>>thanks.
>>>
>>>
>>>M. Sameer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform