SQL Question

[Ruslan Zasukhin]

On 7/23/06 10:33 PM, "Chuck Pelto" <cbpelto at pcisys.net> wrote:

>> You men if add records into cursor?
> 
> No. I mean to reorganize the way the records will appear in a set.
> 
> For instance, in a listbox that has been populated with data from a
> set of records in a VCursor. Initially, the records will appear in
> the order they were found in the database. If the user wants to see
> the records in a different order, e.g., sorted on a particular field
> or three, we need to re-order/sort the records.

And EACH TIME you need new cursor..

In similar way work Valentina Studio. Only Vstudio in its data browswer use
combination of Vtable + ArraySet. And using Vtable.Sort() method.

> It would be a good
> idea to re-organize the records in the VCursor and then repopulate
> the text in the listbox cells.

No.

Because different kinds of queries return different kinds of cursors
"internally". 

> This is because, as I've set things
> up, double-clicking on a record in the listbox takes the user to that
> particular record in a form view. Then, when the user clicks on the
> bevel buttons to go to the next record, he SHOULD be going to the
> next record as re-ordered. Or so I think.
> 
> So, how does one change the order of records without having to do
> another SQL SELECT call?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]