It seems that the TTable Lookup method scrolls the table.

Delphi Help says: "Description: Call Lookup to search for a record in the
dataset in which specified fields contain specified values and return other
field values from the found record. Unlike other dataset search methods,
Lookup performs its search without moving the record pointer of the dataset.
This is useful when doing data validation on a record's data while the
record is still in edit or insert mode."

Lookup method really belongs to TBDEDataset. Is the implementation different
for EDB?

Royke

Roy,

> It seems that the TTable Lookup method scrolls the table.

TTable.Lookup does NOT move the record pointer.

> Lookup method really belongs to TBDEDataset. Is the implementation
> different for EDB?

TEDBTable.Lookup doesn't move the record pointer too, if that is what you
are asking.

--
Fernando Dias
[Team Elevate]

Roy


Why do you think Lookup is moving the cursor?

Roy Lambert [Team Elevate]

I should have been a bit clearer: when called during an Insert (same table
as the Lookup) it cancels the Insert.  Maybe that is asking a bit much ...

Roy

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:63500431-00DB-4224-BC55-426F7C1CB228@news.elevatesoft.com...
> Roy
>
>
> Why do you think Lookup is moving the cursor?
>
> Roy Lambert [Team Elevate]
>

Roy


Same table, same cursor or same table, different cursor?

Roy Lambert [Team Elevate]

Same table, same cursor. Which, as I wrote before, may be asking a bit much.

Roy

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:FDA9F64F-7A74-4C1A-AEA3-C802B7CCB6CF@news.elevatesoft.com...
> Roy
>
>
> Same table, same cursor or same table, different cursor?
>
> Roy Lambert [Team Elevate]
>

Roy


>Same table, same cursor. Which, as I wrote before, may be asking a bit much.

Yes it is <vbg> you need to use a separate cursor.

Roy Lambert [Team Elevate]