Current Position:Home > (261936172) Q DBC Multiple rows from Database Control method?

(261936172) Q DBC Multiple rows from Database Control method?

Update:11-30Source: network consolidation
Advertisement
Q<DBC> Can you give an example of returning multiple rows from a database?
A<DBC> A Database Control method can return multiple rows.
Assuming the SQL for the method can return multiple rows from
the database, what does the method return? It may return an
Array of Objects*, an Iterator (on a Collection of Objects*)
or a java.sql.ResultSet.
Attached is code that gives an example of returning multiple
rows (not the entire files, but text from them).
* the Objects are either user defined or a HashMap
[rows.txt]

The Best Answer

Advertisement
hi Keshav,
Earlier i was using same variable SEL in internal table and as a selection column as well. In that case, it was marking SEL as 'X' even when document was selected.
Today, i tried making selection column name as 'MARK' and internal table field name as 'SEL', it is working fine. I am able to read table control lines where MARK equals 'X'.
[http://www.sapdev.co.uk/dialog/tabcontrol/tc_mark.htm]
I followed this link provided by you. Its really useful. Thanks for your help.
Thanks to others as well.
Thanks,
Archana
  • (261936172) Q DBC Multiple rows from Database Control method? Update:11-30

    Q<DBC> Can you give an example of returning multiple rows from a database? A<DBC> A Database Control method can return multiple rows. Assuming the SQL for the method can return multiple rows from the database, what does the method return? It m

  • How to get multiple rows from database table? Update:10-11

    hello ! I need to get multiple rows from a OLEDB database table and display them on a table object. I did "Wrap in subfrom" on the table,  set  subform of the table to "flowed", and checked "Repeat row for each data item" of

  • Inserting Multiple Rows into Database Table using JDBC Adapter - Efficiency Update:10-11

    I need to insert multiple rows into a database table using the JDBC adapter (receiver). I understand the traditional way of repeating the statement multiple times, each having its <access> element. However, I am just wondering whether this might be

  • Custom database functoid to return multiple rows from database Update:11-30

    Hi, I have created a custom database fucntoid to execute a stored procedure which returns just single row from the database.But I could not manage to return multiple rows from the database. Does anyone know how to return multiple rows from DB and cre

  • How can we select multiple rows in table control for module pool program? Update:11-30

    hi guru's              i cannt able to select multiple table control rows for deletion of records please give any code to select rows? regrards, satheesh.On the Table Control attributes there is a "Selectability" option where you choose one of:

  • Send multiple rows to database from a dynamic table. Update:11-30

    I'm using JSP for my application. I have a table that changes in size depending on a value a user selects in a drop down list. They can then enter some values into the table and click the submit button. I know for whatever reason Dreamweaver only sen

  • First row is repeting while accessing multiple rows through Database adapte Update:11-30

    Hi, Iam using Database adapter in BPEL process to retrive the data from remote database.In Database adapter i have selected select operation and passing input parameter. Actually that adapter needs to return 10 different rows though output variable o

  • Inserting multiple rows into database table Update:11-30

    hi I have a simple jsp/html page like this: <h1>Enter Comments</h1>    <select name = "g1">         <option>10</option>         <option>20</option>         <option>30</option>         <opt

  • Inserting multiple rows into database using c# Update:11-30

    Hi, I have a web form with a customer id and a few checkboxes with different products (productid) and when a user checks the checkbox he must also enter a date for that product.  I need to basically do the following insert into Customer  (customerid,

  • Multiple Row Transaction and prepareForDML method Update:11-30

    Hi I want to create dept and employees record on the same page. For each employee record I created I want to update the average salary field on dept table and create some employee related records. For this I override the prepareForDML method on Emplo