Question: we want to create a **list view** using adapter and we want to set the properties of the the list item outside the adapter.

For instance ,the list view contains **200 rows and 14 column,** then we need to create the list item using adapter.Here the objects in adapter is creating based on the which items shown in screen.

After creating adapter ,after outside adapter we want to put getter,setter for the item 198 means .If initially in device the items upto 10 is diplayed means then then 10 items objects is created in adapter but the remaining is created when user scroll down

So null pointer execption is arised for the item 198.

I want to create a ListView as a custom component.In that the user can add any number of rows,any number of columns,etc

Any items as a list view,etc.

My aim is to create **library for list view** .In that list view user can add any number of rows,any number of columns,any items textview,spinner,etc.I need suggestions how to achieve it 

All are welcome to give their ideas.

Answer: 
I didn't try with Informix but most databases support `insert into ... select`:

```
insert into emp(emp_id, sal, desg) 
select 111, salary, 'xxx' 
from emp_sal where emp_id = 222;

```
The statement as written should work as long as the sub-query returns a single row.

Proof of Concept:

```
SQL[1871]: create temp table x(i integer, j integer, s char(10));
SQL[1872]: insert into x(i,j,s) values(1, (select atomic_number from elements where name = 'Carbon'), "Elephant");
SQL[1873]: select * from x;
1|6|Elephant
SQL[1874]: 

```

My test database has a table of elements in it, hence the sub-select works for me. Warning: I tested on 11.70.FC6, not 7.31. Your mileage may vary given that you appear to be using a much older version of Informix (7.31 was first released before Y2K, IIRC, though 7.31.UDn was a fix-pack from the mid-2000's, probably circa 2005).