🚀 go-pugleaf

Hi,

Thought I wouldn't get an answer because I don't think there is an
answer when working with MS products.   

I found that if I use the SHAPE command on the first Master-Detail and
then thereafter use the TADOTable components for linking the rest of
the Master-detail tables I get what I'm looking for - and it works :-)

Andre

jorhaypi@mweb.co.za (Andre Hayward) wrote:

>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