Mytable: Locate only searches forward?

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
sean

Mytable: Locate only searches forward?

Post by sean » Wed 17 Nov 2004 23:24

Hi,

I've migrated many PDOX Ttables to MyTable, and I use "Locate" for searching for a row. I've now a situation within a MyTable, where Locate only searches forward, returning false if the target if before the current row.

Unidirectional=flase, by the way.

Why? Is this a bug?

Sean

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: Mytable: Locate only searches forward?

Post by Ikar » Thu 18 Nov 2004 08:13

We couldn't reproduce the problem. Please send us complete small sample to demonstrate it and include script to create server objects.

Please supply us following information

- Exact version of Delphi, C++ Builder or Kylix
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL and MySQL client libary (libmysql.dll). You can see it in Info sheet of TMyConnection Editor

GEswin
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain
Contact:

Post by GEswin » Thu 18 Nov 2004 10:49

I also noticed that Locate has some weird problem. Normally it works, but from time to time it doesn't. Perhaps in a grid i do 10 locates, and at 11th locate it doesn't work. I'm not being able to reproduce this as a demo sample, neither find any asociation of the problem to any procedures.

Guest

Locate sometimes does not work

Post by Guest » Thu 18 Nov 2004 19:23

Hi

I have also found a problem .Locating on time fields.

The problem semed to be related to the decimal represenation of the time being a recurring decimal. Finite length decimals were not a problem.


To get around this I now use string fields for the time and I have not had an occurrance of an unreliable Locate.

grahamm

boran

locate problems

Post by boran » Thu 18 Nov 2004 20:42

> We couldn't reproduce the problem. Please send us complete small sample to demonstrate it and include script to create server objects.

It a big application, I can't do that easily at all. Basically I have a query in a grid that shows a subset of records, when I click on a record a second window opens with an edit screen for that record. The second screen uses the MyTable, and the first screen does a locate on Mytable before opening the second edit screen.
Its probably some kind of interaction problem between the query and table, since on the edit screen iteslef I can locate within the table fine).
Looks like maybe the cursors are blocking earch other or limiting locates, does that make sense.?

> Exact version of Delphi, C++ Builder or Kylix
Delphi 7.01

> Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
3.30.0.12 (a week or two old)

> Exact version of MySQL and MySQL client libary (libmysql.dll). You can see it in Info sheet of TMyConnection Editor
4.1.3 direct

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Fri 19 Nov 2004 15:35

Please specify the type of fields in the table and type of parameter passed to Locate. If possible, please send to MyDAC support email address small demo project to demonstrate how you call Locate method and pass its parameters. What are the values of TMyTable, TMyQuery properties?

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: locate problems

Post by Ikar » Mon 22 Nov 2004 13:29

Looks like maybe the cursors are blocking earch other or limiting locates, does that make sense.?
Is it possible that you use FetchAll = False somewhere?

Post Reply