Re: Inserting Data on top

2001-11-19 Thread Sandeep Murthy
: Re: Inserting Data on top Hello Sandeep! I am trying to insert data from a form which has 4 fields such that the data always sits at the top in my database occupying locations : SEC_ID: 1, 2 , 3 4 Everytime i insert data the data gets appended at the end i,e, if the first 4

Inserting Data on top

2001-11-16 Thread Sandeep Murthy
Hi all, I am trying to insert data from a form which has 4 fields such that the data always sits at the top in my database occupying locations : SEC_ID: 1, 2 , 3 4 Everytime i insert data the data gets appended at the end i,e, if the first 4 fields are occupied my data takes the postions

Re: Inserting Data on top

2001-11-16 Thread jim barchuk
Hello Sandeep! I am trying to insert data from a form which has 4 fields such that the data always sits at the top in my database occupying locations : SEC_ID: 1, 2 , 3 4 Everytime i insert data the data gets appended at the end i,e, if the first 4 fields are occupied my data takes the

Re: Inserting Data on top

2001-11-16 Thread Loyd Goodbar
INSERT always places data at the end of the table. SQL makes no assumptions about the ordering of data. If you specify no order, you get arrival sequence, being the order the data was written to the table. If you want to see the data in a certain order, you must order it with the ORDER BY clause