Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate from cursor into original table
Message
 
 
To
24/08/2001 09:29:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00548578
Message ID:
00548595
Views:
8
Instead of a cursor, you can use a View and have the built-in capabilities of having the view update the underlying table.

When creating the view, add ".f. as lSelected" in the Functions and Expression textbox and click on Add. Your new expression will show up in the view. The function won't show up in the Update Criteria but it will show up in both the Order By and Group By tabs.

HTH.

>Hello all
>
>i'll want to perform the following:
>Envirenment:
>1 Table, 1 Cursor of the Table with additional fields (select *, .f. as lSelected from Table)
>now i want to write the values back from the cursor to the original table
>
>is it possible without
>scan
>replace blahblah with cursor.blahblah
>endscan
>tableupdate() only updates the cursor itself as far as i've figured out
>
>thx in advance
>
>Christian
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform