Insert into middle

Hello,

I am inserting data to two table from ASP (both are referenced). The data
in the second table must be inserted as per the order i entered(atually same
order mentioned on the paper). Everything is ok. If i forgot to enter 3rd
record, the total output will be wrong. I can enter seperately but it will be
added at the end of current record. What i want is to add at particular
position.
How can i add a record in middle of existing recordset. I am using Access
2000 DB. Its jus like "insert into tablename before recordnumber"

Thanx in advance

Re: Insert into middle

You can't.

Record 1 order1
Record 2 order2
Record 3 order4
Record 4 order5
Record 5 order6

now you want to insert order3 in record 2 an half, thats not possible.
Insert order3 in Record6 and use ORDER BY

SELECT * FROM MyOrders ORDER BY OrderNr





"Rajani" schreef in bericht
news:F78129B0-342F-4E59-90C7-B32FF65AC12F@microsoft.com...
> Hello,
>
> I am inserting data to two table from ASP (both are referenced). The data
> in the second table must be inserted as per the order i entered(atually
> same
> order mentioned on the paper). Everything is ok. If i forgot to enter 3rd
> record, the total output will be wrong. I can enter seperately but it will
> be
> added at the end of current record. What i want is to add at particular
> position.
> How can i add a record in middle of existing recordset. I am using Access
> 2000 DB. Its jus like "insert into tablename before recordnumber"
>
> Thanx in advance

Re: Insert into middle

A table is an unordered set of rows. There is no such thing as "inserting a
record [sic] in the middle." You insert the row, and the engine decides
where to put the row. If you want to see the data in a specific order *AT
QUERY TIME*, then use an ORDER BY statement.

--
http://www.aspfaq.com/
(Reverse address to reply.)




"Rajani" wrote in message
news:F78129B0-342F-4E59-90C7-B32FF65AC12F@microsoft.com...
> Hello,
>
> I am inserting data to two table from ASP (both are referenced). The
data
> in the second table must be inserted as per the order i entered(atually
same
> order mentioned on the paper). Everything is ok. If i forgot to enter 3rd
> record, the total output will be wrong. I can enter seperately but it will
be
> added at the end of current record. What i want is to add at particular
> position.
> How can i add a record in middle of existing recordset. I am using Access
> 2000 DB. Its jus like "insert into tablename before recordnumber"
>
> Thanx in advance

Re: Insert into middle

Once again Aaron, what is the difference between my and your answer?

"Aaron [SQL Server MVP]" schreef in bericht
news:OQwDZr1uEHA.1420@TK2MSFTNGP10.phx.gbl...
>A table is an unordered set of rows. There is no such thing as "inserting
>a
> record [sic] in the middle." You insert the row, and the engine decides
> where to put the row. If you want to see the data in a specific order *AT
> QUERY TIME*, then use an ORDER BY statement.
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> "Rajani" wrote in message
> news:F78129B0-342F-4E59-90C7-B32FF65AC12F@microsoft.com...
>> Hello,
>>
>> I am inserting data to two table from ASP (both are referenced). The
> data
>> in the second table must be inserted as per the order i entered(atually
> same
>> order mentioned on the paper). Everything is ok. If i forgot to enter 3rd
>> record, the total output will be wrong. I can enter seperately but it
>> will
> be
>> added at the end of current record. What i want is to add at particular
>> position.
>> How can i add a record in middle of existing recordset. I am using Access
>> 2000 DB. Its jus like "insert into tablename before recordnumber"
>>
>> Thanx in advance
>
>

Re: Insert into middle

Is this a suggestion that his post should not have been made? If so:

1. Why are you assuming he even saw your answer before posting his?
2. Why should there be any difference between your answers? The correct
answer is the correct answer.
3. Why shouldn't he attempt to provide a little expansion on or
clarification of a previously posted reply?

Bob Barrows

John wrote:
> Once again Aaron, what is the difference between my and your answer?
>
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: Insert into middle

Once again? What are you talking about?

And are you saying our answers are identical? I don't think they are.

Let me know if you think I should stay out of this newsgroup so that you can
post the only reply to any thread you're involved in.

--
http://www.aspfaq.com/
(Reverse address to reply.)




"John" wrote in message
news:h0tfd.24$Zz7.47151@phobos.telenet-ops.be...
> Once again Aaron, what is the difference between my and your answer?
>
> "Aaron [SQL Server MVP]" schreef in bericht
> news:OQwDZr1uEHA.1420@TK2MSFTNGP10.phx.gbl...
> >A table is an unordered set of rows. There is no such thing as
"inserting
> >a
> > record [sic] in the middle." You insert the row, and the engine decides
> > where to put the row. If you want to see the data in a specific order
*AT
> > QUERY TIME*, then use an ORDER BY statement.

Re: Insert into middle

> 1. Why are you assuming he even saw your answer before posting his?
With a difference of 4 hours ?? Are you still connected with 56 kps modem?

> 2. Why should there be any difference between your answers? The correct
> answer is the correct answer.
Why to 2 answers? It only confuse things.

> 3. Why shouldn't he attempt to provide a little expansion on or
> clarification of a previously posted reply?
Pfff


ONCE AGAIN, Yes Aaron, you have the bad habit to give the same answer, or do
i call it 'little expansion on or clarification of'. You must understand
that English is not the native language of all posters. Unnecessarily to
repeat them in correct English. Or is this the way to become the title of
MVP?

Re: Insert into middle

> > 2. Why should there be any difference between your answers? The correct
> > answer is the correct answer.
> Why to 2 answers? It only confuse things.

Like I said before, I really don't think the two answers are identical. Let
others be the judge of that, instead of just coming out and accusing me of
being an asshole based on your own stupid assumptions.

> ONCE AGAIN, Yes Aaron, you have the bad habit to give the same answer, or
do
> i call it 'little expansion on or clarification of'. You must understand
> that English is not the native language of all posters. Unnecessarily to
> repeat them in correct English. Or is this the way to become the title of
> MVP?

Yes, this is how you become an MVP, by being a parrot.

Get used to it, because now that you're in my killfile, I won't see your
posts at all.

Re: Insert into middle

John wrote:
>> 1. Why are you assuming he even saw your answer before posting his?
> With a difference of 4 hours ??

Why do you think the timestamp on a message determines whether or not
someone has received it? This is the internet. And even if he has received
it, why do you assume that he has read it? I very often answer a question
without reading the other replies.

> Are you still connected with 56 kps
> modem?

Me? No, I have a cable modem. I can't speak for Aaron. Even if he did have a
56kps modem, why do you think that would have anything to do with whether or
not his ISP's news server has received your post, given the well-known
vagaries of the internet? And even if he had downloaded it, why do you think
your answer was definitive enough to not need some
reinforcement/clarification?


>
>> 2. Why should there be any difference between your answers? The
>> correct answer is the correct answer.
> Why to 2 answers? It only confuse things.
>
>> 3. Why shouldn't he attempt to provide a little expansion on or
>> clarification of a previously posted reply?
> Pfff

Don't be silly. Read it again. His post gave some details about relational
database theory that yours only hinted at. If I was the OP, I would be
grateful to receive both replies. This is not a show-up-the-other-repliers
contest. Just because he replied does not mean he thought your reply was
deficient. Relax. We're friends here.

>
>
> ONCE AGAIN, Yes Aaron, you have the bad habit to give the same
> answer, or do i call it 'little expansion on or clarification of'.
> You must understand that English is not the native language of all
> posters. Unnecessarily to repeat them in correct English. Or is this
> the way to become the title of MVP?

No. I submit that you should go to the MVP website and see the list of
hundreds of non-English speakers in those ranks. You should drop this now.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: Insert into middle

Maybe you can get MS to add
microsoft.public.only.john.can.answer.*

Bob Lehmann

"John" wrote in message
news:Fqwfd.288$_r.358510@phobos.telenet-ops.be...
> > 1. Why are you assuming he even saw your answer before posting his?
> With a difference of 4 hours ?? Are you still connected with 56 kps modem?
>
> > 2. Why should there be any difference between your answers? The correct
> > answer is the correct answer.
> Why to 2 answers? It only confuse things.
>
> > 3. Why shouldn't he attempt to provide a little expansion on or
> > clarification of a previously posted reply?
> Pfff
>
>
> ONCE AGAIN, Yes Aaron, you have the bad habit to give the same answer, or
do
> i call it 'little expansion on or clarification of'. You must understand
> that English is not the native language of all posters. Unnecessarily to
> repeat them in correct English. Or is this the way to become the title of
> MVP?
>
>
>
>
>

Re: Insert into middle

I end this conversation with asking Aaron, Bob and Bob to check older
posting. Aaron never sees the posting before. Strange, must always repeat
what is already posted (with a little nuance) and more than once other
people leave a little question for Aaron asking why he repeat things or even
like me asking where the difference is. Here we call people like Aaron not
asshole but 'wise-nouse'. Somebody who knows things better then other. I
wonder if Bob Barrows boss must know how much time he spend on the
newsgroups instead of working, his boss want disconnect his open line to the
net :-))