🚀 go-pugleaf

Hi,

When using 'beginAppend' to add records to the end of a rowset, the server
generates an error:
' [MS Access97  driver] Query too complex'. This only happens in the
browser, not when the IB app (version 1.5) is run from the IB designer. The
(empty) rowset is first generated by executing a rather simple query(q4,
see below).

Just before the error occurs the server 'debug'-log (deb.txt) shows a very
long line (64k) beginning with 'ContentFieldList:'

We have no idea what is causing this error; could it be the ODBC driver or
the configuration of BDE ? We are using Access95 database, but some of the
Access97 ODBC drivers are present on the system (are these downward
compatible ?)

One of the possible workarounds, using the native Access driver, doesn't
work, because we don't how to access the autorisation file (.mdw) from IB

any help is welcome,

Aart Vermetten,
WL | Delft Hydraulics

Code samples:
------------------------------------
 with (this.query4 = new Query()){
      left = 84;
      top = 2;
      database = parent.database1;
      sql = "select * from D_FIELDWORK where EDMED_ID=-1898411187";

      active = true;
   }
----------------------------------
The query is used in this function (query7 is also simple, extracts recs
from one table)

function button1_onServerClick()
   {      
     form.text10.value = form.query7.rowset.fields["SITE_NAME"].value;
     form.text11.value = form.query7.rowset.fields["LATITUDE"].value;
     form.text12.value = form.query7.rowset.fields["LONGITUDE"].value;
     form.text53.value = form.query7.rowset.fields["SITE_NAME"].value;
     form.text54.value = form.query7.rowset.fields["LATITUDE"].value;
     form.text55.value = form.query7.rowset.fields["LONGITUDE"].value;
    
     form.query4.rowset.beginAppend();
     this.form.pageno = 2;
   }