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
To: IBObjects@yahoogroups.com
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
>look..?

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
following:

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
SELECT)
.
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.

Helen




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - 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:
http://groups.yahoo.com/group/IBObjects/


* To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com <mailto:IBObjects-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .



_____

Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.
http://www.mailguard.com.au






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