TAdoQuery updateable joined query

From: Samir Ribic (samir.ribic_at_alemsistem.com.ba)
Date: 11/26/04

  • Next message: Andrew Lockwood: "Connecting to Microsoft Outlook folders" 
    Date: 25 Nov 2004 16:30:33 -0800

    I have TAdoQuery component where the query is generated from two
    tables (main and lookup). When the new value ID in the main table is
    entered, I refresh description fields that came from the lookup table
    on the screen, because master and lookup tables are jonied via that
    ID. Then I try to post. However, ADOExpress/DBGo has no
    TADOUPdateDataSet, so it tries to update fields from lookup table,
    does not know how to do it and displays
    Insufficient key column information for updating or refreshing

     I do not want to send fields from lookup table to the database.
    Property Unique Table is related only for deleting. I need something
    like ProviderFlags for selecting which ADO field will be updated.

  • Next message: Andrew Lockwood: "Connecting to Microsoft Outlook folders"

    Relevant Pages

    • Re: Constant message: "page cannot be displayed ... cannot find serv
      ... > Internet Explorer continually displays a blank page with above message. ... After 3 or 4 REFRESH the page will often appear, ... You would see this symptom if your DNS was slow doing a lookup for you. ... If nslookup times out trying to do the lookup you have your answer. ...
      (microsoft.public.windows.inetexplorer.ie6.browser)
    • Re: Refresh Data
      ... Do you mean a pivot table? ... except when I update the data in the lookup table. ... The help command tells me to use the refresh data command, ...
      (microsoft.public.excel.programming)
    • [patch 2/2] fuse: delete inode on drop
      ... When inode is dropped (no more references) delete it from cache. ... There's not much point in keeping it cached, when a new lookup will ... refresh the attributes anyway. ...
      (Linux-Kernel)
    • Re: An unknown error has occured...
      ... Do you have lookup fields defined? ... when you run out of the IDE with debug set to stop on errors. ... with things like using a cache, how does the system know when to refresh the ...
      (borland.public.delphi.database.ado)
    • Udate Lookup
      ... I have created a list in a lookup. ... Please tell we there is a way to refresh the data. ... redesign all my forms each time there is a change in the list. ... Prev by Date: ...
      (microsoft.public.access.forms)