V4RB2: Question about Cursor

[Ruslan Zasukhin]

On 5/15/05 10:23 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

> Hi,
> 
> at the moment I do following.
> 
> With SQL I build Cursor and publish it to ListBox. When I update or
> insert something I do it in a routine with
> 
> mydatabase.Table1.Field1.value=XXXX
> 
> or something similar.
> Then I build new cursor with same SQL and publish it ahain to ListBox.
> 
> Now my question.
> My Cursor is a cursor ORDER BY table.date
> 
> when I now wants to Update database during Cursor. I have to Update
> cursor. But when I change table.date is ORDER BY from Cursor still
> alive and new record or updated record is in correct ORDER BY or is
> it at the same place where old record was with old ORDER BY?

Order of records is NOT corrected after changes.
I think any db do not do this.

Why? Because cursor already do not have indexes and so on.
 

> I think it is difficult to describe I want to make an example:
> 
> Cursor has following
> 
> Place in Cursor - Date - other datas
> 1 - 15.05.2004 - ..........
> 2 - 15.08.2004 - ..........
> 3 - 01.02.2005 - ...........
> 4 - 05.04.2005 - ...........
> 
> when I now Update record at place 3
> from 01.02.2005 - ...........
> to 01.02.2004 - ...........
> 
> how does Cursor looks like
> 1 - 15.05.2004 - ..........
> 2 - 01.02.2004 - ...........
> 3 - 15.08.2004 - ..........
> 4 - 05.04.2005 - ...........
> 
> or
> 
> 1 - 15.05.2004 - ..........
> 2 - 15.08.2004 - ..........
> 3 - 01.02.2004 - ...........
> 4 - 05.04.2005 - ...........
> 
> Thanks for help

-- 
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]