"Insufficient base table information for updating or refreshing" ???

From: PP (paulo_at_endosoft.com.br)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 10:40:46 -0300

what is this error on ADO Query when I try to refresh...
"Insufficient base table information for updating or refre"

Ado Query:

object qCampanha: TADOQuery
  Connection = dmMain.cntWytronDir
  CursorType = ctStatic
  ParamCheck = False
  Parameters = <>
  SQL.Strings = (
    'select * from camp'
    'where ID > 0'
    ' ')
  Left = 176
  Top = 208
end

ADO Connection:
object cntWytronDir: TADOConnection
  Connected = True
  ConnectionString =
    'Provider=MSDASQL.1;Password=DragonBall65;Persist Security Info=T' +
    'rue;Data Source=CampAtual'
  LoginPrompt = False
  Mode = cmReadWrite
  Left = 16
  Top = 20
end

Could somebody help me again?

PP

Relevant Pages

  • Re: "Insufficient base table information for updating or refreshing" ???
    ... With best regards, Mike Shkolnik ... > what is this error on ADO Query when I try to refresh... ... > object qCampanha: TADOQuery ... > ADO Connection: ...
    (borland.public.delphi.database.ado)
  • Advice: closing objects after query in Access DB
    ... I have a function that I can call on the fly that takes a SQL argument and then executes an ADO query. ... I really like this functionality and it works great, BUT I can't close the connection in the usual manner inside the function because the function actually returns the recordset. ... Does this hurt anything since the connection is never closed, or does it matter? ...
    (microsoft.public.data.ado)