Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What am I doing wrong?
Message
From
03/07/1998 03:19:13
Larry Long
ProgRes (Programming Resources)
Georgia, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
What am I doing wrong?
Miscellaneous
Thread ID:
00113990
Message ID:
00113990
Views:
53
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
Next
Reply
Map
View

Click here to load this message in the networking platform