Skip to Content
author's profile photo Former Member
Former Member

DBDatasource and Matrix

In 'Purchase Order' Screen, there is a matrix bound to DBdatasource. when each row gets filled up, the next row gets automatically enabled.

How to implement this feature?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 09, 2004 at 12:32 PM

    Standard document screens in business one add a new row to the matrix when a valid entry is made in a key field on the last current row on the screen.

    You can implement something similar for your own matrices by processing the et_VALIDATE event for a key item in your matrix. If your custom validation is successful and the current row = matrix.rowcount, then call matrix.addrow.

    Regards,

    John.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I usually find UserDataSources most useful for data entry matrices. I find they give you more flexibility when you want to update them through code. Make sure you use GetLineData/SetLineData to populate them rather than going through the matrix cells. UserDataSources do have DataType & Length properties that will allow them to do basic type validation/display.

      One area I do use DBDataSources extensively is when the matrices are mostly read-only lists of existing items in the database (eg. Orders due for delivery). They are very quick and easy to to generate and when used with Conditions objects provide quite good performance particularly on larger data sets. Even these however are often supplemented by UserDataSources for some items.

      To prevent jerks when adding lots of lines to a matrix you can freeze the screen before starting to populate the matrix, un-freeze and update afterwards.

      As you are experiencing, there doesn't really seem to be one ideal way of doing it at the moment. I think however that the enhancements to DBDataSources in the 2004 version might make a big difference to how we all work with matrices.

      Regards,

      John.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.