Start Delphi insufficient base table information for updating or refreshing

Delphi insufficient base table information for updating or refreshing

I just need to refresh it so that a couple of the columns are updated with new numbers. Is there a way to use TBetter Ado here that would solve my problem?

-- Chris Keating Sybase Adaptive Server Anywhere Professional Version 8 i Anywhere Solutions ** Please only post to the newsgroup ** Whitepapers can be found at Anywhere.com/developer ** EBFs can be found at Use Case Xpress to report bugs Re: "Insufficient base table information for updating or refreshing"Date: Mon, 0100Lines: 91X-Priority: 3X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6700X-Mime OLE: Produced By Microsoft Mime OLE V5.00.2919.6700Message-ID: Newsgroups: sybase.public.sqlanywhere.general NNTP-Posting-Host: 195.1Path: forums-1-dub!

I only use table A to primary key to link primary B.

Should I have all the table B composite key fields in the select query? Inung Huang than more joined resolve Cheers, I have a view which joins 4 tables, and im doing insert/updates on just one of the tables. I have a TAdo Dataset that uses a couple of MS SQL 2k views as the datasource (inner joined). The final result returns columns that include the primary key of one of the base tables and the rows that are returned are absolutley unique. I am able to navigate the grid that displays the dataset without any trouble.

-- Ian Mc Hardy (i Anywhere Solutions) Please reply only to the newsgroup.

Whitepapers, Tech Docs, bug fixes are all available through the i Anywhere Developer Community at Subject: Re: "Insufficient base table information for updating or refreshing"Date: Fri, 0100Lines: 56X-Priority: 3X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6700X-Mime OLE: Produced By Microsoft Mime OLE V5.00.2919.6700Message-ID: Newsgroups: sybase.public.sqlanywhere.general NNTP-Posting-Host: 195.1Path: forums-1-dub! forums.Xref: forums-1-dub sybase.public.sqlanywhere.general:4041 Article PK: 881716 Subject: Re: "Insufficient base table information for updating or refreshing"Date: Fri, -0500Lines: 79X-Priority: 3X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106X-Mime OLE: Produced By Microsoft Mime OLE V6.00.2800.1106Message-ID: Newsgroups: sybase.public.sqlanywhere.general NNTP-Posting-Host: 1.19Path: forums-1-dub! forums.Xref: forums-1-dub sybase.public.sqlanywhere.general:4025 Article PK: 842755 The 8.02 MR was just released and has no publically available EBFs.

Using server-side cursors is not an option for me at this time. Subject: Re: Insufficient base table information for updating or refreshing Date: Tue, -0500Lines: 36X-Priority: 3X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700X-Mime OLE: Produced By Microsoft Mime OLE V5.50.4807.1700Message-ID: Newsgroups: sybase.public.sqlanywhere.general NNTP-Posting-Host: 158.159.8.16Path: forums-1-dub! forums.Xref: forums-1-dub sybase.public.sqlanywhere.general:14281 Article PK: 844911 Subject: Please Read** Re: Insufficient base table information for updating or refreshing Date: Wed, -0500Lines: 46X-Priority: 3X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200X-Mime OLE: Produced By Microsoft Mime OLE V5.50.4522.1200Message-ID: Newsgroups: sybase.public.sqlanywhere.general NNTP-Posting-Host: 1.60Path: forums-1-dub! forums.Xref: forums-1-dub sybase.public.sqlanywhere.general:14273 Article PK: 844910 Subject: Re: Insufficient base table information for updating or refreshing Date: Wed, -0500Organization: Versa Trans Solutions Inc.

Reply-To: [email protected]: X-Newsreader: Forte Agent 1.8/32.548MIME-Version: 1.0Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Newsgroups: sybase.public.sqlanywhere.general Lines: 10NNTP-Posting-Host: 64.80.1.106Path: forums-1-dub! forums.Xref: forums-1-dub sybase.public.sqlanywhere.general:14270 Article PK: 885880 That's unfortunate, I get extensive use out of the client-side cursor features in ADO.

I only update one field of table B, should I update all the table B primary key, even I do not need update those fields? so i made a instead of trigger (insert/update) to accomplish this, this seems to work for the insert but not on the updates, in delphi it gives me this error, but but when i do it on the sql query analyser it works (updateing the view). The grid is not editable of course because the data source is too complex.