ADO Locate not working



Just to clarify/simplify a previous posting.

if A.Locate('Val', BVal.Value, []) then
showmessage(AVal.Value+'='+BVal.Value);

If the above shows the message that message should always show
foundstring=samestring ie xxxx=xxxx not yyyyy=xxxx - Right? It
doesnt, it shows wrongstring=searchedforstring.

This is irrespective of master detail or anything - a simple
locate but it aint working. Is it an ADO thing? Do I need to
change all my locates to Select Count?

This is in D6 on an ADO table with SQL Server 2000.

Pat Bell

.



Relevant Pages

  • Re: ADO Locate not working
    ... > Just to clarify/simplify a previous posting. ... whatever it is in the FieldByName method ... Is it an ADO thing? ...
    (borland.public.delphi.database.ado)
  • Re: Messages Tab in SQL Server 2000
    ... messages that usually show up in the Messages tab of Query analyzer ... some of the previous questions in this newsgroup before posting yours - ... but this is a classic ADO newsgroup. ...
    (microsoft.public.data.ado)
  • RE: "Select @@IDENTITY" and Access 95/97 ?
    ... Thank you for posting in the community! ... I would like to confirm my understanding of your issue. ... Here are another two KB articles about how to retrieve the identity in ADO: ... "This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.data.ado)
  • Re: Unable to create CDO.Message for Workflow application
    ... This is the code I use to send a message from the Workflow Sink ... It doesnt have all the configuration code you use and works fine ... ADO installed. ...
    (microsoft.public.exchange.development)
  • Re: Runtime Error 2001: You canceled the previous operation
    ... for this posting because the database is on a classified ... >it is a keyword in both DAO and ADO. ...
    (microsoft.public.access.modulesdaovba)