🚀 go-pugleaf

Hi,

I'm getting the following EOleException when connecting to an Access
database with the Jet Data Provider and the Shape Service Provider

'Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record'.

Three tables are linked: Company, Address and Person.  The CommandText
on the Company TADODataSet is:

SHAPE  {select * from company order by CompanyCode} 
APPEND ((

SHAPE {Select * from Address order by AddressCode} As ChapAddress
APPEND({select * from Person order by LastName} as ChapPerson
   RELATE AddressKey TO AddressKey))

   RELATE CompanyKey TO CompanyKey)

The ADODataSets for Address and Person are linked with the
DataSetFields property with the values obtained from the above SHAPE
command.

Using BCB5Ent with update#1 installed as well as ADOUpdate#1
installed.

 Any advise will be appreciated.

Thanks in advance.

Andre