Paul,

<< with DmL.TblLeden do
    begin
    if overname=true then edit else Append;
    fieldbyname('Naam').asstring:=EdtNaam.text+' '+Edtvoornaam.text;
    fieldbyname('Straat').asstring:=Edtadres.text+' '+EdtHuisnummer.text;
    fieldbyname('Postcode').asstring:=EdtPostcode.text;
    fieldbyname('plaats').asstring:=EdtPlaats.text;
    fieldbyname('geboortedatum').asdatetime:=strtodate(mskgeboorte.text);
    fieldbyname('actief').asstring:='A';
    fieldbyname('A_S').asboolean:=true;    //// default actieve speler
    if (bondslid.ItemIndex=0) then
       begin
       fieldbyname('aansluitdatum').asdatetime:=date;
       fieldbyname('status').asstring:='';
       end;
    if (overname=true) and (bondslid.ItemIndex=1) then fieldbyname('aansluitdatum').clear;
    positie:=Getbookmark;
    post;
    gotobookmark(positie);
    freebookmark(positie);
    end;
>>

Why should you use BookMark functions inside your code ? It does nothing in your code and I think it must be a problem. Just comment out the lines
with BookMark functions and see if the errors still happens.

Eduardo

Jose Eduardo Helminsky <eduardo@hpro.com.br> wrote:

Paul,

<< with DmL.TblLeden do
    begin
    if overname=true then edit else Append;
    fieldbyname('Naam').asstring:=EdtNaam.text+' '+Edtvoornaam.text;


   Why should you use BookMark functions inside your code ? It does nothing in your code and I think it must be a problem. Just comment out the
lines
with BookMark functions and see if the errors still happens.

Eduardo

I receive the errorcode "Table not in edit or insert mode" just after the append line...
The code worked correctly for years... and still works correct on my table.
+ I have the problem with a customers table even after I did a repair with forceindexrebuild (to be sure table and indexes are OK)

Paul.

Paul,

Sorry for not being more clear - I really need the code *in context*, i.e. a
project that demonstrates the issue.  The issue is most likely related to a
lookup field, etc., and a code snippet doesn't give me that information.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Paul,

Sorry for not being more clear - I really need the code *in context*, i.e. a
project that demonstrates the issue.  The issue is most likely related to a
lookup field, etc., and a code snippet doesn't give me that information.

--
Tim Young
Elevate Software
www.elevatesoft.com

The problem continues and only with the dataset of 1 customer.  I repaired the table, rebuild the indexes...

Can it have something to do with a master-detail relationship with other tables (The "problem" table=master)

Paul.

Paul,

<< Can it have something to do with a master-detail relationship with other
tables (The "problem" table=master) >>

Sure.  If anything causes the master record to move, it will force a refresh
of the detail table's linkage and cause the detail table to revert to browse
mode.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Paul,

<< Can it have something to do with a master-detail relationship with other
tables (The "problem" table=master) >>

Sure.  If anything causes the master record to move, it will force a refresh
of the detail table's linkage and cause the detail table to revert to browse
mode.

--
Tim,

OK. The detail table had a record where tha value for the "masterfield" was NULL.  When I remove this record from the detail table the problem is solved.
Now I'am just wondering how this record got in the detail table???  But that is another problem.

Paul

Paul,

<< OK. The detail table had a record where tha value for the "masterfield"
was NULL.  When I remove this record from the detail table the problem is
solved. Now I'am just wondering how this record got in the detail table???
But that is another problem. >>

Hmm, a NULL master column in the detail table, by itself, will not cause the
problem that you mentioned, even with a master-detail link established.  It
would simply be excluded from visibility when the master-detail link was
established/refreshed.

--
Tim Young
Elevate Software
www.elevatesoft.com