Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I set the 'SendUpdates' property for a View?
Message
De
28/07/2000 13:15:52
 
 
À
28/07/2000 12:55:42
Jimmy Ditta
Twin City Electronics
Monroe, Louisiane, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00398241
Message ID:
00398254
Vues:
25
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform