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!
Mark McCasland
Midlothian, TX USA