Locate and ADO wont work

From: Stephan Blind (stephan.blind_at_gmx.de)
Date: 08/31/04 

Date: 31 Aug 2004 03:23:35 -0700

Hi i am so desparated....

worked for some years with D5 and BDE...all seemed to be good.
Now i toggle a project from bde to ado (with an access 2003).

After recognizing that i cant set indexes....i threw away the good old
findkey method...now using LOCATE.
All works fine....but when i have to find a row using more than one
column for Locate there is an exception wrong type of arguments
In the Table the field PID and LNR are together primarykey (both long
int)

I tried these versions

==================================================
if KAAdoTable1.Seek_Nearest ( [1,2] ) then
==================================================
if KAAdoTable1.ExecSQLString ( 'select * from Test4 where PID=1 and
Lnr=2' )
==================================================
KAAdoTable1.EditKey();
KAAdoTable1.FieldByName ( 'PID' ).AsInteger := i1;
KAAdoTable1.FieldByName ( 'Lnr' ).AsInteger := i2;
if KAAdoTable1.GotoKey() then
==================================================
suche := VarArrayOf ( [1,1] );
if KAAdoTable1.Locate ( 'PID;Lnr', suche, [] ) then
==================================================

all versions show the same error.....

would be glad i anyone in this small world could help me

stephan

Relevant Pages

  • D7 & ADO with ASA9: EOLEException & Multiple-step error
    ... If I rest my pointer over the ".AsString" part of AdoDataMod.aquGetClipReadOnly.FieldByName.AsString, I get the yellow ribbon hint with the text "Delphi Exception EoleException at ... I tried removing the fields from the ADO query, I tried adding them back in again, I tried closing everything and rebooting - so far so bad... ... The BDE version has been working with identical data for nearly 10 years without a hitch - it still is. ...
    (borland.public.delphi.database.ado)
  • Re: BDE support??
    ... > We have an application that is using controls descended from TDatabase, ... > we'd like to convince the higher ups to ditch the BDE and move to ADO. ... Very nice for unit testing, ...
    (borland.public.delphi.non-technical)
  • Re: Conversion from BDE to ADO
    ... I've noticed no performance problems with ADO and MSSQL. ... conversion). ... > I am currently experimenting with converting a quite large app from BDE to ...
    (borland.public.delphi.database.ado)
  • ADO and BDE interact on XP SP2?
    ... It uses the BDE ... indirectly to connect to a database. ... also optionally uses ADO to connect directly to the database for ... but of course any built in initialisation will have taken place. ...
    (borland.public.delphi.database.ado)
  • Re: Enhancing ADO Performance
    ... > currently have applications constructed to retrieve data from ODBC ... > worked with both because of the installation issues when using the BDE ... It seems that ADO ... of data and hooking to a DB grid, use a server-side cursor. ...
    (borland.public.delphi.database.ado)