🚀 go-pugleaf

Yes. On client-side cursor (CursorLocation = clUseClient) ADO makes updates
by executing SQL commands like

UPDATE TableName SET Col1 = NewValue WHERE Col1 = OldCol1Value AND Col2 =
OldCol2Value ...

In case you have no primary key and have rows with same values in all
columns ADO can not locate row you want to update. Having primary key should
solve your problem.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Borut Sustar" <borut@bokosoft.si> �������/�������� � �������� ���������:
news:3e75a614@newsgroups.borland.com...
>
> No!Should i have it?
> Borut
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
> news:3e74b678@newsgroups.borland.com...
> > Do you have primary key (or at least unique index) on this table?
> >
> > ----------------------------------------------------------------
> > Regards,
> > Viatcheslav V. Vassiliev
> > http://www.oledbdirect.com
> > The fastest way to access MS SQL Server, MS Jet (MS Access)
> > and Interbase (through OLEDB) databases.
> >
> > "Borut �u�tar" <borut@bokosoft.si> �������/�������� � ��������
���������:
> > news:3e749aab@newsgroups.borland.com...
> > > Error : 'ROW CANNOT BE LOCATED FOR UPDATING. SOME VALUES MAY HAVE
> CHANGED
> > > SINCE IT
> > > WAS LAST READ'.
> > >
> > > "Borut �u�tar" <borut@bokosoft.si> wrote in message
> > > news:3e749a74@newsgroups.borland.com...
> > > > I can add (read only=false) records and delete them, but when i try
to
> > > > change them an error is thrown!
> > > >
> > > >
> > > >
> > > > "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in
message
> > > > news:3e72e342@newsgroups.borland.com...
> > > > > You should be able to edit record with these settings. Check
> > > > > TADOTable.ReadOnly property.
> > > > >
> > > > > ----------------------------------------------------------------
> > > > > Regards,
> > > > > Viatcheslav V. Vassiliev
> > > > > http://www.oledbdirect.com
> > > > > The fastest way to access MS SQL Server, MS Jet (MS Access)
> > > > > and Interbase (through OLEDB) databases.
> > > > >
> > > > >
> > > > > "Borut �u�tar" <borut@bokosoft.si> �������/�������� � ��������
> > > ���������:
> > > > > news:3e723546@newsgroups.borland.com...
> > > > > > Hello!
> > > > > >
> > > > > > I am using MSSQL, BCB6,ADO! Why isn't possible to edit records
if
> > this
> > > > > > settings are used:
> > > > > > -cursorLocation = clUserClient
> > > > > > -Cursor Type = ctDynamic
> > > > > > -Lock Type = ltOptimistic
> > > > > > -Table direct = true;
> > > > > > What settings should I use, to make it possible to edit records
> > (Table
> > > > > which
> > > > > > i am trying to edit is on local computer)!
> > > > > >
> > > > > > Thx in advance!
> > > > > > Borut
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>