Appeon Comunidad

Preguntas y Respuestas Comunidad de Appeon
Appeon Community

  1. DW with Group (get the number of selected row)

    Hello,

    I have a DW with GROUP . There is 4 rows in trailer group section of DW (originally there is 5 rows).

    GetRow() - always returns 1

    row parameter in click() or DoubleClick() event - returns 1

    1. How do I get the number of the specific row that I click on in grouped DW?

    2. How to copy only visible rows from grouped DW to another? (visible - I mean only grouped rows , that stayed after the group, the 4 rows)

    Regards,

    Marina

     

  2. Powerbuilder Database Profile Not Displaying

    In Powerbuilder 2019 R3, I open my Database Profile and do not see ODBC. It was there a couple of days ago, but now it's gone. What's strange is I have a default profile set up within ODBC and that default connection still connects when I open a datawindow or open the Database painter. So I "sort of" still have the ODBC connection, it's just not visible for me to switch databases, update passwords, etc. in the Database Profile painter. 

  3. Replicating SyntaxFromSQL in SnapDevelop

    We are converting our Client / Server Application and trying to implement our Custom Data Query Tool that allows our clients to Generate a dataset from a SQL query and display the results in a dynamic datawindow with the SyntaxFromSQL method.   This allows our clients alot of flexibility to gather data easily through our application.

    Looking to see if anyone has implemented the SyntaxFromSQL in a Cloud Application or has any kind of work around.

    The code for our Client/Server Application looks like this:

    String ls_sql
    string ERRORS, sql_syntax
    string presentation_str, dwsyntax_str
    String ls_sysidSyntax
    Long ll_trows


    ls_sql = mle_query.Text

    presentation_str = "style(type=grid)"

    dwsyntax_str = SQLCA.SyntaxFromSQL(ls_sql, presentation_str, ERRORS)

    If Len(ERRORS) > 0 Then
        MessageBox("Error", "SyntaxFromSQL caused these errors: " + ERRORS)
        Return
    End If

    dw_data.Create( dwsyntax_str, ERRORS)

    IF Len(ERRORS) > 0 THEN
       MessageBox("Caution","Create cause these errors: " + ERRORS)
       RETURN
    END IF

    dw_data.SetTransObject(SQLCA)
    ll_trows = dw_data.Retrieve()
    st_rows.text = String (ll_trows ) + ' Rows Retrieved'

    dw_data.Modify("DataWindow.Export.PDF.Method = NativePDF! ")

    dw_data.BringToTop = TRUE

    Thanks
    Jim Beck

     

  4. Change background.transparency in nested report object - PB2022 R3

    I have been tasked with adding a watermark to printed documents. 

    Before printing, I copy the dataobject into a local datastore, copy the data (RowsCopy), add the watermark to the background (Modify("CREATE...")), and then make the background for each of the objects transparent (Modify("<name>.Background.Transparency='100'")), so the watermark is visible.

    My problem is nested reports. I need to reach into those reports and make the background of each of those objects transparent as well.

    As an example, I have a nested report object, dw_1, and an object on that report, last_name, that needs a transparent background.

    These all work:

    lds_print.Object.dw_1.Object.last_name.Background.Transparency="100"

    lds_print.Object.dw_1[1].Object.last_name.Background.Transparency="100"

    DWbject ldwo
    ldwo = lds_print.Object.dw_1[1]
    ldwo.Object.last_name.Background.Transparency="100"

    But I need to be able to do this dynamically, I am not going to know the names of the objects in the nested reports.

    None of these work:

    lds_print.Modify("dw_1[1].Object.last_name.Background.Transparency='100'") >>> Line 1 Column 5: incorrect syntax.

    lds_print.Modify("Object.dw_1[1].Object.last_name.Background.Transparency='100'") >>> Line 1 Column 12: incorrect syntax.

    lds_print.Modify("Object.dw_1.Object.last_name.Background.Transparency='100'") >>> Line 1 Column 47: incorrect syntax.

    lds_print.Modify("dw_1.Object.last_name.Background.Transparency='100'") >>> Line 1 Column 41: incorrect syntax.

    lds_print.Modify("dw_1[1].last_name.Background.Transparency='100'") >>> Line 1 Column 5: incorrect syntax.

    lds_print.Modify("dw_1.last_name.Background.Transparency='100'") >>> Line 1 Column 34: incorrect syntax.

    Am I missing something, am I not going to be able to do this dynamically?

    Any input is appreciated.

  5. AccessibleName is not accessible in PB22 R3 but PB21

    Hello,

    We have a solution developed with PB21 where it uses AccessibleName property (by singlelineedit, commandbottom objects.. not in Dw) Available in MSAA and UI Automation Mode. Using the "Narrator" (an external app) our application in PB21 describes the value in the "AccessibleName" property followed by the text value when it is selected (or getfocus)...which really works for us. After migrating to PB22 R3 it only describes the text value, the "AccessibleName" property is not accessible anymore....

    I tried swapping values of the "Accessibility" property within PB.INI also changing the "AccessibleRole" property without having better results.

    Do you know if I have to change any parameters in PB22 R3 so that it works again with the "Narrator" like in PB21?

    Thank you!