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!