Sending View Updates to base tables.

[andyk]

Hi,

I have a complicated view which I have been using to update its base tables. In the latest release of my software it has stopped updating the base one of the bases tables.

To debug I simplified the view to just get two fields (the primary index & the field I'm trying to update) from a single table and still the base table is not being updated.

Here's the views SQL:

create sql view as SELECT;
company.ip_company,;
company.f_name;
FROM company_db!company

I'm saving the view as v_company and executing the following to send the updates:

DBSETPROP('v_company','View','SendUpdates',.T.)

Any ideas why the updates aren't reaching the base 'company' table?

Thanks in Advance,

Andy

 

[fluteplr]

when you execute a tableupdate are you checking to see if it returned .t. and if not what is the value of message() at that point?

Is it possible that ip_company which I assume is the primary key for the table is not set as a primary or candidate key and has duplicate values?