Good Morning Tore!

But then I would not run a grid against a plain SELECT SQL, I use this for straight processing only.

I mean views and changing views was a big problem, but since we have CA's this is gone.

Is there any other advantage in this approach?

Lutz

>I'm sorry, I mixed up with a grid.
>
>>Hi Tore,
>>
>>This confuses me. Isn't that what VIEWS and CA are made for and REQUERY() is used?
>>Also Listboxes with RowSourceType = 3 will simply refreshed with ListBox.REQUERY()
>>
>>The idea to bound a Listbox to a cursor created with SELECT SQL that is not in ROWSOURCE or CA/VIEW is the problem.
>>Using a SQL SELECT and then bound to its cursor is wrong approach to me.
>>
>>If listboxes cursor is needed for anything else, ist's still no problem because
>>

>> .cboi1V4_1.ROWSOURCETYPE = 3
>> .cboi1V4_1.ROWSOURCE = ;
>>  'SELECT'+;
>>  ' Cur1.cName,'+;
>>  ' TRANSFORM(Cur1.iObj_Ix,"'+dcTrans_Int+'") AS ci1V4_1'+;
>>  ' FROM '+THISFORM.gcCur_Requery_i1V4+' AS Cur1'+;
>>  ' INTO CURSOR curcboi1V4_1'
>>