Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What am I doing wrong?
Message
De
03/07/1998 03:19:13
Larry Long
ProgRes (Programming Resources)
Georgie, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
What am I doing wrong?
Divers
Thread ID:
00113990
Message ID:
00113990
Vues:
54
When I create view using the code below and make a change to the nquantity field and move on to the next record, I get a message saying that there are "no update tables specified". Any help or ideas would be greatly appreciated!

store ipmasterview.keyfield to m.cpackid

IF NOT INDBC('IPDVIEW','VIEW')
CREATE sql view ipdview as ;
SELECT Ipdetail.*,Ipclass.citemclass, Icitem.cdescript, Icitem.cstatus,;
Icitem.cclass,Icitem.cprodline, Icitem.nprice;
FROM amw!Ipclass, amw!Ipdetail LEFT OUTER JOIN amw!Icitem ;
ON Ipdetail.citemno = Icitem.citemno ;
WHERE Ipdetail.cclassid = Ipclass.keyfield AND ipdetail.CPACKID=m.cpackid ;
ORDER BY Ipdetail.cclassid, Ipdetail.citemno
ENDIF

if not used('ipdview')
sele 0
use ipdview
endif

=CursorSetProp('Buffering',3,'ipdview') &&opt row buffering
=CursorSetProp('SendUpdates',.t.,'ipdview')
=CursorSetProp('UpdateType',1,'ipDview')
=CursorSetProp('WhereType',3,'ipdview')
=CursorSetProp('FetchAsNeeded',.t.,'ipdview')
=CursorSetProp('FetchMemo' ,.t.,'ipdview')
=CursorSetProp('Keyfieldlist','keyfield','ipdview')
=CursorSetProp('prepared',.t.,'ipdview')
=CursorSetProp('UpdatableFieldList','keyfield,cpackid,cclassid,nquantity,citemno,ddateadded,ddatechanged','ipdview')
=CursorSetProp('tables','ipdetail','ipdview')
L.A.Long
ProgRes
lalong1@charter.net
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform