ProDataBindingSource

Posted by resperger on 07-Aug-2008 03:58

I work on a program which has a dataset (containing about 7 temp-tables) as datasource.

How do I build the BindingSource without typing every table and field?

I tried to add the original files to no avail.

How does one do that?

Thanks very much

Josef Resperger

Initiative EDV Ges.mbH

OpenEdge Development - Forum

All Replies

Posted by Admin on 07-Aug-2008 04:01

You need to create an XML schema definition file (XSD) using the WRITEXML-SCHEMA method of the dataset.

One of buttons (if I remember the right most one) of the Binding Source Designer let's you import the XSD file and you shoudl see your 7 table and all fields in the binding source designer.

Posted by Simon de Kraa on 07-Aug-2008 04:22

...and some of this is described in the OpenEdge® Getting Started: Introducing the OpenEdge Architect Visual Designer.

The example files are in C:\Progress\OpenEdge_102A1B_Doc\src\prodoc\visualdesigner.

And there is some sample code for WRITE-XML-SCHEMA in the ProKB if you need it...

Posted by Admin on 07-Aug-2008 04:25

And there is some sample code for WRITE-XML-SCHEMA in

the ProKB if you need it...

Just to avoid confusion: It's WRITE-XMLSCHEMA (no second dash).

Posted by Simon de Kraa on 07-Aug-2008 04:45

Ah! Found another "bug" in the docs...

Note: Creating an XML Schema Definition (XSD) file is a portable and efficient way to describe the schema of a data source. You can create XSD files from databases, temp tables, or ProDataSets with the ABL WRITE-XML-SCHEMA method.

Posted by resperger on 07-Aug-2008 05:12

Hi!

Thanks so far. I'v done that. Dataset was obviously exported correct with all tables and keys. But import to Prodatasource did import only first table!

Is this a bug?

Josef

Posted by Simon de Kraa on 07-Aug-2008 05:32

I have tried it on one of the XSD files from the SampleAppSolution and no problems there...

Note that I did not generate the XSD file myself.

[View:~/cfs-file.ashx/__key/communityserver-discussions-components-files/19/bePurchaseOrder.cls:550:0]

[View:~/cfs-file.ashx/__key/communityserver-discussions-components-files/19/purchorder.xsd:550:0]

Posted by resperger on 07-Aug-2008 05:48

Well I know this stuff - tried it myself. Made a new bindingsource now and tried again. Same problem. Have submitted my XSD to betasupport in the meantime.

Thanks

Posted by Admin on 07-Aug-2008 06:04

Works for me like documented and always did.

Just curious: Do you have data-relations defined in your prodataset?

Posted by resperger on 07-Aug-2008 06:58

no I did not!

Posted by Admin on 07-Aug-2008 07:04

does it work when you add those relations?

Whitout then you have 7 top level queries. I'd be surprised if that works.

Posted by resperger on 07-Aug-2008 07:59

You are right. It is working now.

I did not need that before

Thanks

Posted by resperger on 07-Aug-2008 08:01

You are right. It is working now.

I did not need that before

Thanks

This thread is closed