will recommend using a TIMESTAMP to avoid all these "acrobaties".
Thanks
Emery
- Original Message -
From: "dorilys" <[EMAIL PROTECTED]>
To: "'Roger Baklund'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, October 19, 2003 03
Hi,
> If your table has a primary key or unique integer key you can order
> descending using the keyword "_ROWID" like this:
>
> SELECT * FROM table WHERE NUMERO='248' ORDER BY _ROWID DESC;
>
I just tried your solution but unfortunately I got an error
My table have no key
In fact my pro
* dorilys
> I have a little question
> I have a big table ( a lot of fields) whitout keys
> In order to got a list sorted by the time of insertion
> I build a sequential acces with this syntax
>
> SELECT * FROM table WHERE NUMERO='248' ;
>
> It's was perfect
No, you were just lucky. That syntax wi
I have a little question
I have a big table ( a lot of fields) whitout keys
In order to got a list sorted by the time of insertion
I build a sequential acces with this syntax
SELECT * FROM table WHERE NUMERO='248' ;
It's was perfect
But now I woulf like got this list with inverse order
Sure I