Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
EDIT SQL results
Message
From
24/10/2000 10:12:39
 
 
To
22/10/2000 17:22:12
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00432623
Message ID:
00433453
Views:
15
I wasn't actually referring to the addition of the 'NOFILTER' as much as using the dbf() function to get the temp table name that VFP would use.

SELECT ... INTO CURSOR MyCursor NOFILTER
USE (dbf('MyCursor')) SHARED AGAIN IN 0 ALIAS MyWritableCursor

BOb



>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
Reply
Map
View

Click here to load this message in the networking platform