Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I set the 'SendUpdates' property for a View?
Message
From
28/07/2000 13:15:52
 
 
To
28/07/2000 12:55:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00398241
Message ID:
00398254
Views:
20
SELECT LEFT(SUBSTR(Inventory.p_descript,1,AT("$",Inventory.p_descript,2)+8),50) AS memotxt, Inventory.item_status,;
Inventory.trans_id, Inventory.stocknum;
FROM tomparco!inventory ;
INTO CURSOR trans_items ;
WHERE Inventory.trans_id = trans_num ;
ORDER BY Inventory.stocknum


Cursors created with a SELECT ... INTO CURSOR are not updatable.

If the cursor doesn't have too many records,immediately after you can do this, though:
AFIELDS(laFields)
CREATE CURSOR cu_updatable_trans_items FROM ARRAY laFields
APPEND FROM (DBF("trans_items"))
Otherwise, you can create a view in the database for this.

HTH
Insanity: Doing the same thing over and over and expecting different results.
Previous
Reply
Map
View

Click here to load this message in the networking platform