Insufficient base table information for updating scunthorpe telegraph dating
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. I was getting the msg:insufficient key column information for updating and refreshing. I was loading combo boxes which I learned how to do on Tek Tips thank you very much. Recordset Dim con String As String Dim s Code As String Dim s Elig As String Dim s Elig2 As String Dim s Need As String Dim s Need2 As String Set ado Combo = New ADODB. Well I decided to get fancy and try and load two combos at once. I am building an Application form and a few of the combo options that apply to the applicant also apply to the spouse (ie. So I figured what the HEY since they are coming from the same table I'll load the Applicants combo and the Spouse's all at the same time. As proof of my dum-dum move here is the code: Public Sub Load Combos()Dim ado Combo As ADODB. 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. There are a couple of instances on this form where I need to refresh the dataset.
Both tables have primary, table A has one field primary key, but table B has 4 fields composite key. When I do so I get "insufficient key column information for updating or refreshing" If I set the dataset to active = false and turn it on again that works fine but I really don't want to do that. 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? Close Set ado Rec = Nothing Set ado RS4 = Nothing Set ado RS5 = Nothing End Sub Just thought I would pass that a long, I hope this helps someone. I agree with the default properties and use of a banger. Field obeject variable is also one point I mentioned which is faster when accessing multiple properties and methods of a field (or whatever).
No, that's not what I meant.(I guess I wasn't feeling too good yesterday and didn't explain thouroughly or correctly.
Hi VB'ers I just discovered something I thought I would pass along.