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

> Geno,
>
> By any chance, does the table have an Update trigger?
> Does the error message occur immediately after myQuery.Edit? after
> myQuery.Post? elsewhere?

There are no triggers. Error occurs as soon as I say qremployee.edit

>
> Other than that, I'm afraid I'm stumped. Perhaps one of the many

more

> knowledgable people (Helen, Jason, Claudio) can jump in.
>

Thanks for trying to assist. Yes, hopefully someone will have an
answer. It is obviously something I am doing on my form since I can
create another for to access the database and I CAN edit from that
form.

Thanks again

> Art Metz
> AMetz@n...
>
> > -----Original Message-----
> > From: Geno [mailto:strtline@a...]
> > Sent: Wednesday, December 27, 2000 10:24 AM
> > To: IBObjects@egroups.com
> > Subject: [IBO] Re: Can not edit current row
> >
> >
> > --- 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!
> >
> > Keylinks 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.
> >