Subject RE: [IBO] Cant Edit Current Row
Author Craig Stevens
Thanks.... this has worked, my data is now being edited, i added a PK to KeyLink & set RequestLive to true.

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Wednesday, 2 February 2005 9:22 AM
Subject: Re: [IBO] Cant Edit Current Row

At 08:40 AM 2/02/2005 +1000, you wrote:

>Can anyone make a suggestion ?
>I have converted a SQL Server DB to FDB, and am accessing using
>IBODatasets, however, when i go to make a change to any of the rows that
>appear in my DBGRID i get the error 'Cant edit current row',
>Has anyone crossed this and is there a simple solution, or direction to

Output from SQL is, by nature, not editable. To "edit" datasets (or insert
or delete) the data access components do stuff to hook up DML statements
that are bound to the columns of the SELECT statement output. You need the

1. Set the KeyLinks (this is a stringlist of the columns that go to make
up a unique key for the output set - the primary key columns in a simple
2. Set RequestLive true (if the set is a simple SELECT) or set EditSQL,
DeleteSQL and InsertSQL properties (parameterised SQL statement strings) if
it is a joined set or a selectable stored procedure.


IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Yahoo! Groups Links

* To visit your group on the web, go to:

* To unsubscribe from this group, send an email to: <>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <> .


Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.

[Non-text portions of this message have been removed]