EDatabase Error with ADO Query

From: Kimberly Mills (kimmills_at_indiana.edu)
Date: 10/25/04 

Date: Mon, 25 Oct 2004 15:42:15 -0500

I used an ADO query to access a table of values in an Access 2000 database.
I continue to get 'EDatabase Error.... field not found.' I then replaced the
query with a table and continue to get the same error. I have set the Active
to true in the object inspector, but somewhere along the way it becomes
inactive....

Here is my code......

function TCommonDataModule.AchieveDeadline(appdate: TDateTime): string;
var a : string;
begin
   if AwardSpecTable.Active then a := 'y';
   if appdate <= AwardSpecTable.FieldByName('ACHIEVE_DEADLINE').AsDateTime
then Result := 'y';
end;

I put the test in there to see if it remained active when invoking this
function, it is not.

The fields from the database are used in several functions and procedures
prior to this call.

Any ideas? If you need more information, please let me know. I am starting
to get a headache from banging my head against the wall with this one.

Kim Mills

Relevant Pages

  • Re: A little Rolodex [revised]
    ... including alpha sort and searching for any embedded string, ... In this application, a database is a directory, ... you may optionally provide any alternate UCASE program, ... NN -> first store NN as key length ...
    (comp.sys.hp48)
  • Re: return multiple rows from sql statement
    ... strings from input values is almost certainly a safe path to SQL ... Also, being a MySQL function, it knows what MySQL needs or uses. ... All characters that are entered in the fields make their way into the database unaltered. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
    (comp.lang.php)
  • Re: Code to delete/unlink Linked tables
    ... Public intLinkODBCTables As Variant, intLinkDB2Tables As Variant ... Public strLinkBackendDB As String, strLinkDSNname As String, strLinkLibName ... ' MsgBox "This database is in MDE format...I will delete/recreate ODBC ... Public Sub fncLinkDB2Table() ...
    (microsoft.public.access.modulesdaovba)
  • Re: Establish connection with and transferring data to Access
    ... The specific problem with your code is that you need to quote string ... Dim vConnection As New ADODB.Connection ... Experiment with the object model or check the documentation for the ... Doug's code opens and writes to an existing database. ...
    (microsoft.public.word.vba.general)
  • Re: Invalid variant type conversion
    ... because within regular programming, there would be no agreement upon what ... applications built by standard Delphi controls, ... NULL is the same as "" in a database. ... >> The empty string tells it all. ...
    (comp.lang.pascal.delphi.misc)