[icf-dev] Dynamics 2 Dynamic SDO

I'm afraid the Dynamic SDO does not yet support buffers.

HÃ¥vard

-Original Message-

From: Martin Bos

Sent: Wednesday, February 05, 2003 5:21 PM

To: dev@icf.possenet.org

Subject: Dynamics 2 Dynamic SDO

Hi,

I just installed POSSE Dynamics 2 and did an entity import of my own DB.

I just generated a simple SDO (1 table), viewer, browser and

assembled it to a independent window.

That looks good!

Now a started from the AB to create a new dynamic SDO:

- I created 2 buffer2 (shipper_name_address and consignee_name_address)

for the table cmc_name_address.

- I build a query like:

FOR EACH CMDB.cmt_consignment NO-LOCK,

EACH CMDB.cmt_shipment OF CMDB.cmt_consignment NO-LOCK,

EACH shipper_name_address WHERE

shipper_name_address.name_address_obj =

CMDB.cmt_consignment.shipper_address_obj NO-LOCK,

EACH consignee_name_address WHERE

consignee_name_address.name_address_obj =

CMDB.cmt_consignment.consignee_address_obj NO-LOCK INDEXED-REPOSITION

- Added all fields of these buffers to the SDO.

When saving I get the following error:

Message (Press HELP to view stack trace)

Object not saved to repository.

SDO field shipper_name_address.agent_ix has no datafield.

You must generate DataFields for all SDO fields.

Aborting the saving of SDO cmtcnsmtfullo.

OK Help

How do I get these datafields in the repository? Actually why do I need to

create them since shipper_name_address

is an extra buffer on table cmc_name_address ?

Note:

We are using buffers very much in SDO's.

Any help would be appreciated.

:-((

-Original Message-

From: Havard Danielsen

Sent: Wednesday, February 05, 2003 11:31 PM

To: dev@icf.possenet.org

Subject: RE: Dynamics 2 Dynamic SDO

I'm afraid the Dynamic SDO does not yet support buffers.

HÃ¥vard

-Original Message-

From: Martin Bos

Sent: Wednesday, February 05, 2003 5:21 PM

To: dev@icf.possenet.org

Subject: Dynamics 2 Dynamic SDO

Hi,

I just installed POSSE Dynamics 2 and did an entity import of my own DB.

I just generated a simple SDO (1 table), viewer, browser and

assembled it to a independent window.

That looks good!

Now a started from the AB to create a new dynamic SDO:

- I created 2 buffer2 (shipper_name_address and consignee_name_address)

for the table cmc_name_address.

- I build a query like:

FOR EACH CMDB.cmt_consignment NO-LOCK,

EACH CMDB.cmt_shipment OF CMDB.cmt_consignment NO-LOCK,

EACH shipper_name_address WHERE shipper_name_address.name_address_obj

= CMDB.cmt_consignment.shipper_address_obj NO-LOCK,

EACH consignee_name_address WHERE

consignee_name_address.name_address_obj =

CMDB.cmt_consignment.consignee_address_obj NO-LOCK INDEXED-REPOSITION

- Added all fields of these buffers to the SDO.

When saving I get the following error:

Message (Press HELP to view stack trace)

Object not saved to repository.

SDO field shipper_name_address.agent_ix has no datafield.

You must generate DataFields for all SDO fields.

Aborting the saving of SDO cmtcnsmtfullo.

OK Help

How do I get these datafields in the repository? Actually why do I need to

create them since shipper_name_address

is an extra buffer on table cmc_name_address ?

Note:

We are using buffers very much in SDO's.

Any help would be appreciated.