ADO Table -> Tempermental Locate Staement -- Any clues?

Article View: borland.public.cppbuilder.database.ado

Article #474

Back to borland.public.cppbuilder.database.ado Previous Next

#474

From: Caleb
Date: Fri, 19 May 2006 03:35

31 lines
1614 bytes

I am using the following code to locate a rec in a table, and it
usually works in other functions and projects.

For some reason the result is false (locate unsuccessful).

I've verified that the record should be found.

Any ideas as to why it might not work?  



CODE SAMPLE

   if(ADOTabUsers->Active == true)
      ADOTabUsers->Active = false;

   ADOTabUsers->CursorLocation = clUseClient;
   ADOTabUsers->TableDirect = true;
   ADOTabUsers->TableName = "Custs";
   ADOTabUsers->IndexFieldNames = "UserID";

   ADOTabUsers->Active = true;
   Variant varT ;
   varT = Variant (user);
   varT.ChangeType(varString);
   ADOTabUsers->Locate("UserID", varT,
      TLocateOptions() << loCaseInsensitive << loPartialKey);


Is there a limit on the number of ADOTables in a program?

Technical Details

Message-ID: <cqeq62tasqb2viq7oj81ovvpmtljbc07ik@4ax.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news2.volia.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,d674326d20ed910,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: Caleb <nospam@nospam.net>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADO Table -> Tempermental Locate Staement  -- Any clues?
Date: Thu, 18 May 2006 23:35:45 -0400
Reply-To: nospam@nospam.net
Message-ID: <cqeq62tasqb2viq7oj81ovvpmtljbc07ik@4ax.com>
X-Newsreader: Forte Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 71.99.9.44
X-Trace: newsgroups.borland.com 1148009725 71.99.9.44 (18 May 2006 20:35:25 -0700)
Lines: 32
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news2.volia.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail