RE: FOREACH cursor sequence

If you have CLUSTERED INDEX (index in the ORDER that you need) on the
table then you can get rows in sequence without ORDER BY clause ...
=20

-----Original Message-----
From: informix-list-bounces@[EMAIL PROTECTED]
 On Behalf Of Jarrod Teale
Sent: Monday, April 28, 2008 08:28
To: falconsoon@[EMAIL PROTECTED]
 informix-list@[EMAIL PROTECTED]
 RE: FOREACH cursor sequence

If you want to control to order, add an ORDER BY clause to the query
that the cursor is running.
Otherwise you have no control of the order - the rows will be returned
as the database finds them.

Jarrod Teale

-----Original Message-----
From: informix-list-bounces@[EMAIL PROTECTED]
 On Behalf Of
falconsoon@[EMAIL PROTECTED]
 Monday, 28 April 2008 3:22 p.m.
To: informix-list@[EMAIL PROTECTED]
 FOREACH cursor sequence

I have a table with row 1, row 2, row 3, and etc.
If I use foreach cursor to loop through the rows, will the rows been
retrieved in sequence, i.e. follow row 1, row 2, row 3, and etc
sequence? Or it will been retrieved without follow the original
sequence, i.e. may be row 2, row 1, row 3, and etc?

Thanks for anyone who can help to clarify it.
Thanks.
_______________________________________________
Informix-list mailing list
Informix-list@[EMAIL PROTECTED]
 mailing list
Informix-list@[EMAIL PROTECTED]