OpenEdge 11.7.1: BindingSource is not bound to a DataSource

[Bert]

Hello,

I just started to figure out how to use the Telerik 2016.3.1024.40 components with OpenEdge 11.7.1.

Using the RadGridView and BindingSource components I am unable to show the records of one of the tables in my database.

I connected the BindingSource to the table (for example "SomeTable") of my choice and set the RadGridView.DataSource property to the BindingSource. During design-time I see the correct fields of the table, but no records. With the PropertyBuilder the order of the columns can be changed which is also visible in the grid. So far so good.

When I run the application an empty record is shown and when I try to add a new record or edit the contents of the empty record, the message "BindingSource is not bound to a DataSource" is shown.

Do I miss some code to load the records in the grid?

 

When I connect the grid to another BindingSource that is not connected to a table in my database, the following code can be used to display the contents of the table (just to demonstrate that the grid is able to display at least something):

        DEFINE VARIABLE hQuery AS HANDLE NO-UNDO.
        DEFINE VARIABLE hdsSomeTable AS HANDLE NO-UNDO.
        DEFINE DATASET dsSomeTable FOR ttSomeTable.
        FOR EACH SomeTable NO-LOCK:
            CREATE ttSomeTable.
            BUFFER-COPY SomeTable TO ttSomeTable.
        END.
        hdsSomeTable = DATASET dsSomeTable:HANDLE.
        hQuery = hdsSomeTable:TOP-NAV-QUERY.
        hQuery:QUERY-OPEN().
        bindingSource1:HANDLE = hQuery.

Please advise,

Bert

 

[Hristo]

Hi Bert,

Thank you for writing.

The provided information is not sufficient to adequately investigate your scenario. Currently, we are not aware of any issues resulting in the described behavior. 

In order to assist you best on this matter, please open a case in SalesForce which is the preferred channel for OpenEdge related questions. If possible please also attach a sample project reproducing the incorrect behavior.

In the meantime, you can check the Progress Community or Knowledge Base and see if there are any resources handling a scenario similar to yours.

I hope this helps. Should you have further questions please do not hesitate to write back.

Regards,
Hristo
Progress Telerik

[Bert]

Hello Hristo,

It seems that with Progress OpenEdge a BindingSource cannot be used to directly connect to a table in the database, and instead the sample code using a temp-table has to be used.

Bert

 

[Hristo]

Hi Bert,

Thank you for updating the thread. I am glad that you have managed to resolve the issue.

Should you have further questions please do not hesitate to write back.

Regards,
Hristo
Progress Telerik