SQL 2000, VFP6:
Distilled, the code is:
SET MULTILOCKS ON
use mycontainer!fromts2
=CURSORSETPROP('Buffering',5,'fromts2')
=CURSORSETPROP('Tables','fromts2')
append blank
replace myNumField with 1
replace myCharField with "Text"
?TABLEUPDATE(.T.)
The TABLEUPDATE returns a false.
The view has a primary key (ID), and all the fields are updatable. the SQL WHERE clause includes Key and modified fields, and the "Update using" box is set to SQL UPDATE.
Why isn't it updating the SQL file?
TIA,
Joy
PS--I'm on-site today. Any quick help would be greatly appreciated!
CLARC Services, Inc.
3500 Tamiami Trail
Port Charlotte, FL 33952
www.clarc.com(941) 743-0108
(800) 246-5488