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

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

Article #476

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

#476

From: Bud Manz
Date: Mon, 22 May 2006 23:37

33 lines
1885 bytes

Caleb wrote:
> 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?  
> 
Are you sure you have a good connection to the database?

Technical Details

Message-ID: <44724b41@newsgroups.borland.com>

Path:

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

References: <cqeq62tasqb2viq7oj81ovvpmtljbc07ik@4ax.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,d674326d20ed910
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Mon, 22 May 2006 19:37:37 -0400
From: Bud Manz <amanz@northweststate.edu>
User-Agent: Thunderbird 1.4 (Windows/20050908)
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: ADO Table -> Tempermental Locate Staement  -- Any clues?
References: <cqeq62tasqb2viq7oj81ovvpmtljbc07ik@4ax.com>
In-Reply-To: <cqeq62tasqb2viq7oj81ovvpmtljbc07ik@4ax.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 205.133.102.173
Message-ID: <44724b41@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1148341057 205.133.102.173 (22 May 2006 16:37:37 -0700)
Lines: 33
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news.glorb.com!news2.volia.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message