From: Georgios Petasis on
στις 11/6/2010 01:54, O/H tom.rmadilo έγραψε:
> On Jun 10, 10:00 am, drscr...(a)gmail.com wrote:
>> On 6/10/2010 12:34 PM, Georgios Petasis wrote:
>>
>>> Is there a array or a dict involved in foreach? Because the order rows
>>> are examined seems different than in database:
>>
>> I have not used TDBC but in general, a select from a database is not
>> guaranteed to return data in any particular order and may also differ in
>> subsequent runs. If you want a particular order, you can use an order
>> by clause.
>
> Absolutely essential that you use an order-by clause in every query.
> For instance, postgreSQL is known to append updated rows to the bottom
> of a table, so each update query changes the subsequent order of rows
> returned without an order-by clause.

Thank you both DrS & Tom,

I didn't know that you can get a different order by a DBMS, I thought
that results were always return sorted by (the internal) row id.
So, nothing wrong with tdbc :-)

Regards,

George