473,388 Members | 1,068 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

What is the way to receive the data as we entered

Hai ,

I created a table with primary key clustered. I have entered the data
thru E.Manager . If a close the table and open it again , Ii shows the
rows with the (default) ascending order. Is, there any way to get the
rows in the user entered order(neither asc or dec order)
With Thanks
Raghu
Jul 20 '05 #1
2 1282

"Raghuraman" <ra************@rediffmail.com> wrote in message
news:66**************************@posting.google.c om...
Hai ,

I created a table with primary key clustered. I have entered the data
thru E.Manager . If a close the table and open it again , Ii shows the
rows with the (default) ascending order. Is, there any way to get the
rows in the user entered order(neither asc or dec order)
I don't believe so.

Keep in mind that in theory there is no "order" to the way the data is
stored. So the order it was entered is meaningless.

The only way to guarantee the order of output is with an order by statement.
And I don't think you can force that in EM.



With Thanks
Raghu

Jul 20 '05 #2
No. A clustered index physically orders the data.
Even without the index it would not be possible unless design for it -
as Greg D. Moore says tables have no inherent order.

You would need to add an identity or timestamp column and order by
that.
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Sathesh Arumugam | last post by:
Client is sending data a,b,c using seperate send method to the server eg., Socket.Send('a') Socket.Send('b') Socket.Send('c') In the Server we are using Receive method to receive the incoming...
0
by: ?lafur Helgi R?gnvaldsson | last post by:
I'm building a server application which accepts socket connections and I ran into some problems. The socket is asynchronous and therefore uses the BeginXXX and EndXXX methods in the Socket class...
0
by: Shoveler | last post by:
I've got an odd problem here that I've been beating my head on for days. I've written a class that uses a pre-established connection for communication, meaning I can use this class for a server or...
5
by: Ole | last post by:
Hi I'm receiving data from another device that sends data in packages of 8000. In my application I use this code to receive the data: SizeReceived = MySocket.Receive(Buffer, 8000,...
17
by: lokidog | last post by:
I am trying to automatically transfer data from one textbox to another between subforms within a 'main' form. I put this code into the Gotfocus eventprocedure: Private Sub Date_GotFocus() If...
0
by: irfanullah | last post by:
I have written an application for Receiving Stock Market Feed over a 2 Mbps Connection with Exchange with average incoming data of 800kbps. The program works fine for sometime i.e. for an hour or...
1
by: Jason1983 | last post by:
I have a Search form which gets data from the tables that were filled from different forms earlier ....This data entered could be partial data....I mean for example... Name ---...
3
by: Joe Blauth | last post by:
Hi all, I am currently working on a small application that sends messages from a client to a server and receives messages in return. Basically the functionality is made with sockets which is...
5
by: Andrus | last post by:
Steps to reproduce issue: 1. Run code. 2. Enter some data to grid 3. Click other form caption 4. Click original form caption 5. Enter some characters Observed: entered characters are ignored
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.