Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL problems
Message
De
24/09/1998 12:33:31
 
 
À
24/09/1998 10:05:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00140068
Message ID:
00140435
Vues:
33
>>>But once I've run the SQL statement, can I make the resulting cursor updateable the same way that a view can be updateable? If so, what command? Cursorsetprop?
>>>
>>>paul
>>
>>
>>SELECT Blah...blah INTO CURSOR cReadOnly
>>USE (DBF("cReadOnly")) AGAIN IN 0 ALIAS ReadWrite
>>USE IN cReadOnly
>>SELECT ReadWrite
>
>Nope. I want to write back to the original table. Like I would if I were using a view. The "people" table in the above example. ???
>
>paul

You have the old data from the table in your cursor. You have the new data on the screen... Use the an regular UPDATE-SQL statement to update your table.
Alexandre Nobre
Alpha Bytes Computer Corp.

Did you know that there are innocent people dying in East Timor?
It helps if you do...

I suppose you don't need glasses if you're able to read this line

Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform