--- In IBObjects@egroups.com, Art Metz <ametz@n...> wrote:

> Is your query on a single table? If so, does the query have a

primary key?

Query is on single table, has primary key

> If so, be sure the KeyLinks property is correctly set. If not,

well, it

> should!

Keykinks is set to primary key field

>
> If your query is on more than one table, you may need to fill in the
> UpdateSql property.
>
> One last thought: does the user have Update privilege on the table?
>

User has update privliges

> If none of these help, please post the table structure and the

query.

>

Table is rather long but this is basic structure:

empno integer not null primary key
several varchar fields
several integer fields
several double precision fields

primary key is generated. have setup generator and generator links.
This works as I can add records and use the form to move traverse the
records and all fields are correct, including generated key field.

query is simple

select * from employees

table does get some of its values from ib_lookups - this all works

table is linked (as the master) to several other querys. Again, this
works. Plus, have disabled master/detail links and still can not
edit.

> Art Metz
> AMetz@n...
>
> > -----Original Message-----
> > From: Geno [mailto:strtline@a...]
> > Sent: Wednesday, December 27, 2000 9:15 AM
> > To: IBObjects@egroups.com
> > Subject: [IBO] Can not edit current row
> >
> >
> > Hi:
> > Have a form with several querys. One is a query to my main table,

the

> > others are querys to lookups that set values in the main table.

I

> > can add new records to the main table and everything works fine.
> > Problem is whenever I try to edit a record I get "can not edit
> > current row". Thought I must have inadventantly set some

property

> > wqrong in the main query so I deleted it and dropped a new on one
> > form, same problem. Can anyone offer assistance.
> >
> > Thanks
> >
> >
> > -------------------------- eGroups Sponsor
> > -------------------------~-~>
> > eGroups eLerts
> > It's Easy. It's Fun. Best of All, it's Free!
> > http://click.egroups.com/1/9698/1/_/685810/_/977937301/
> > --------------------------------------------------------------
> > -------_->
> >
> >
> >