Locate returns true but does not move my record cursor

Bill N

Delphi Developer

Sat, 26 Nov 2005 02:07:44 GMT

Locate returns true but does not move my record cursor

I have a TADOTable connected to a TADOConnection. The TADOconnection
cursorlocation has been set is set to clUseClient. The TADOTable cursor
Type is ctStatic. The lock type is ltBatchOptimistic. I have a
TCombobox with a drop down list of primary keys for record numbers.
When I run this code:

===========================================================================
if
tblShip.Locate('ShippingID',cboShipRec.Items[cboShipRec.ItemIndex],[])
then ShowMessage('Found ' + cboShipRec.Items[cboShipRec.ItemIndex]);
===========================================================================

The result is true but my bound form does not reflect the cursor
position (based on the locate method returning true).

Why does the locate method return true but my form does not reflect the
new cursor position?

Thanks,
Bill N
www.2rs.ca

Bill

Delphi Developer

Sat, 26 Nov 2005 22:40:43 GMT

Re:Locate returns true but does not move my record cursor

There's good reason why locate will return true and my form does reflect
the cursor position. The reason is because I was suffering from brain
drain and hooked up the wrong TDataSource to my DBControls.

It is amazing how a couple of clicks in the object inspector can fix things.

Thanks,
Bill N
www.2rs.ca

Quote

Bill N wrote:
> I have a TADOTable connected to a TADOConnection. The TADOconnection
> cursorlocation has been set is set to clUseClient. The TADOTable cursor
> Type is ctStatic. The lock type is ltBatchOptimistic. I have a
> TCombobox with a drop down list of primary keys for record numbers. When
> I run this code:

> ===========================================================================
> if
> tblShip.Locate('ShippingID',cboShipRec.Items[cboShipRec.ItemIndex],[])
> then ShowMessage('Found ' + cboShipRec.Items[cboShipRec.ItemIndex]);
> ===========================================================================

> The result is true but my bound form does not reflect the cursor
> position (based on the locate method returning true).

> Why does the locate method return true but my form does not reflect the
> new cursor position?

> Thanks,
> Bill N
> www.2rs.ca

Other Threads

1. TADOTable.Locate returns True for wrong record

2. findkey returns true but fails to set cursor (Delphi 3)

3. DBGrid-How to auto select the record when the mouse cursor move to the record

4. EOF returns true before accessed last record (Delphi 1)

5. BDE VCHKDesc.bHasDefVal returns True when it should not

6. Locate not locating and findkey not finding

7. Cursor will not return to default

8. Cursor not returned from query

9. DataSet1: Cursor not returned from Query

10. cursor not returned from query