It says "No update tables are specified. Use the Tables property of the cursor." But as I'm sure you've noticed by the code below, I do have
>>>>=CURSORSETPROP('Tables','fromts2')
in there.

Eeps.

JR

>After you issue Tableupdate(.t.) and get a false return value, what does AERROR(laError) return? Do a DISP MEMO LIKE laError to see the array element values.
>
>>I am letting SQL do it, and it is not updatable.
>>
>>JR
>>
>>>How are you populating the PK field? Letting SQL Server do it? IF so, do not make the PK field updatable.
>>>
>>>>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!