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
Mytable: Locate only searches forward?
Re: Mytable: Locate only searches forward?
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
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
Locate sometimes does not work
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
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
locate problems
> 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
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
Re: locate problems
Is it possible that you use FetchAll = False somewhere?Looks like maybe the cursors are blocking earch other or limiting locates, does that make sense.?