by QuickFo » Thu, 18 Jan 2001 10:39:37
Please help !!!
on SQL Server 7, I have a view , ViewA that select from a table TableA
on VFP 6, a ADO(2.5) Recordset ,RS use source "Select * from ViewA order by
keyid desc".
When I run Update method, it tell me access denied for update TableA.
why ADO select from ViewA, but update/insert from TableA.
1. Cached Updates QUESTION: Sorting table of updated and non-updated records
When using cached updates I am experiencing a strange phenomena:
The table is constantly sorted when trying to insert new records:
The new, not yet updated records come before the old, updated records..
Why why, oh why???
Please mail me personally and I will post an answer to the newsgroup.
Thanks in advance,
Christian Loft
2. handling 2 PKs in Database App
3. updating same table with trigger(use update or deleted tables)
4. Atlanta-Oracle Designer/Developer 2000 skills Needed
5. Update data in another table when data is updated in current table
6. Ingres Net / ODBC upgrade ?
7. Update Trigger - Updates don't show up in pane view
8. Error: Cannot update identity column
9. INSTEAD OF Triggers to update multiple base tables in a SQL Server 2000 view
10. Resolution - Re: ADP uses underlying table for UPDATE, INSERT instead of view
11. ADP uses underlying table for UPDATE, INSERT instead of view
12. View don't get updated when underlying table schema changes
13. Updating a table with a view