🚀 go-pugleaf

PS: More Info

The table I am having trouble with is the detail in a master/detail
(Client/Person) relationship. The Person table has the Client table as a
DataSource. The query is

Select Person.*
From Person
Where ClientID = :ID
Order by LastName

Using a client cursor the Person.ID and Person.ClientID fields get filled
automatically when an insert is done. With a server cursor they don't seem
to.


"Tony" <hse@hill-soft.com> wrote in message news:3c856b9d_2@dnews...
> I need to change a typical data form (name, address, phone etc.)  from a
> client side cursor to server side. The form uses bound controls and a
> TDBNavigator. The form seems to work OK with server side for Prior record,
> Next record and Update record but on Insert record it throws the error
> "Field ID cannot be modified". The ID field is an auto increment field.
>
> Do I have to use all action queries and unbound controls to do this with a
> server side cursor, or is it possible to use bound controls? If so, what
is
> a good technique for adding records?
>
>