Share this page

# Example: lrd_to_printable

In the following example, lrd_to_printable tells VuGen to display two columns in the grid. In the first column it displays the NAME and in the second column it displays the ID.

The first segment shows the recorded script in the Actions section. The second segment shows the corresponding section (PrintRow14) in the print.inl file generated during recording.

     /* Actions section from run.c */

    unsigned int msg;

    lrd_stmt(Csr1, "select * from Employees", -1, 1, 1, 0);

    lrd_bind_col(Csr1, 1, &NAME_D11, 0, 0);

    lrd_bind_col(Csr1, 2, &ID_D12, 0, 0);

    lrd_exec(Csr1, 0, 0, 0, 0, 1);

    /* Set the log level to enable lrd_to_printable
        before the lrd_fetch */

    msg = lr_get_debug_message();

    lr_set_debug_message
      (msg|LR_MSG_CLASS_EXTENDED_LOG|LR_MSG_CLASS_RESULT_DATA,
      LR_SWITCH_ON);

    lrd_fetch(Csr1, -3, 15, 0, PrintRow14, 0);

    /* Restore the log level */

    lr_set_debug_message(msg, LR_SWITCH_ON);

| NAME_D11 | ID_D12
--- | --- | ---
1 | Kim Smith | 200
2 | Janet Jones | 201
3 | Annette Taylor | 202

     / * PrintRow1 section from print.inl. */

    LRD_PRINT_ROW_PROTO(PrintRow14)

    {

     LRDRET gjLRDRet = LRDRET_I_OK;

     char szNAME_D11[256];

     char szID_D12[256];

    lrd_to_printable(&NAME_D11, muliRowIndex, szNAME_D11, 256, "");

    lrd_to_printable(&ID_D12, muliRowIndex, szID_D12, 256, "");

     lr_debug_message(LR_MSG_CLASS_RESULT_DATA, "%s, %s", szNAME_D11, szID_D12);

     return gjLRDRet;

    }

Tips to improve your search results... VuGen Function Reference Version 25.1-25.3 Function Reference 25.1-25.3 All View Local Help Center View Online Help Center Version: