🚀 go-pugleaf

OK! Thx! Now I understand!

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:3e75f73e@newsgroups.borland.com...
> 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
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>