Hello

I try this"
if MyTable.Locate('Id', myVar, []) then

it's result false even when this sould be true for shure.
I try with myVar as string, as integer, as variant but the result is the
same.
The Id is autoInc field.

When I inspect the code with the debuger and Evaluate/Modify  the Result
window show this:
"Delphi exception ype%gt2<$g?$?$<$gdj< at $1B8EF945"

Thanks for the support
Sorin

Sorin,

<< I try this"
if MyTable.Locate('Id', myVar, []) then

it's result false even when this sould be true for shure. >>

Please send me the database catalog and table files that you're using.

Did you run this on the same table that you were having the ALTER TABLE
issues with ?

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:C3E08A6D-0A10-4191-AAD8-0290CC345E38@news.elevatesoft.com...
> Sorin,
>
> << I try this"
> if MyTable.Locate('Id', myVar, []) then
>
> it's result false even when this sould be true for shure. >>
>
> Please send me the database catalog and table files that you're using.
>
> Did you run this on the same table that you were having the ALTER TABLE
> issues with ?

No different table.

I send the data.

Thanks
Sorin

Solved I found the problem.

The table is the detail table in m/d mode and the master table point to the
wrong record

Thanks and sory for botherig
Sorin