Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
EDIT SQL results
Message
De
24/10/2000 10:12:39
 
 
À
22/10/2000 17:22:12
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00432623
Message ID:
00433453
Vues:
16
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform