Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL problems
Message
From
24/09/1998 12:33:31
 
 
To
24/09/1998 10:05:09
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00140068
Message ID:
00140435
Views:
32
>>>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

Previous
Reply
Map
View

Click here to load this message in the networking platform