Sorting words

[ahmed222too]

i make a text to list vb6 program that segments the text into words and add them in an access table ex. if the input (i go to school), the output will be:
i
go
to
school
the output is in an access table
my question is:
i want to add the segmented words in the access table in their desending order
i want the output to be
to
school
i
go
i want the word to be added in its desending order in the table (i donot want to sort the column after adding words in their original places).
my goal is to make a word frequancy program (in binary search) to be fast.

[lotus18]

The easiest way to this is by using Order By DESC in sql statement.

[CODE=sql]Select <ColumnName> From <TableName> Order By <ColumnName> DESC[/CODE]

[ahmed222too]

The easiest way to this is by using Order By DESC in sql statement.

[CODE=sql]Select <ColumnName> From <TableName> Order By <ColumnName> DESC[/CODE]

iam sorry,
but i want to add each word in its desending order in the table not to order the column after adding words in their original places

[debasisdas]

Then keep adding the records in the order you want.

[Killer42]

I think you'll find that the whole concept of storing words in a specific sequence in a database is fundamentally flawed. It's best to think of the database as a big bucket into which you simply throw a bunch of things. The order in which they come back depends on what you do in your query.

It may be possible to physically store the words in the sequence you want. But what happens if, for instance, you want to add more words later? You'd effectively have to create a whole new copy of the file with the new words inserted. And the order they come out would still depend on (A) the primary key if your table has one, and (B) the way you specify the query.

If you ask about this in the Access forum, I'm sure someone there could explain it better than I can.

That being said, if you really need to sort a bunch of words, one fairly simple method that has been used for many years is to add them all into a listbox control, with the Sorted property set to True. Of course, I don't know what version of VB you're using. This works up to VB6, at least.


P.S. Perhaps a database isn't appropriate for your purposes. You might find it simpler to store your data in a text file.

[ahmed222too]

Then keep adding the records in the order you want.

iam sorry
i donot understand your reply
could u clearify your words please
thank u

[ahmed222too]

I think you'll find that the whole concept of storing words in a specific sequence in a database is fundamentally flawed. It's best to think of the database as a big bucket into which you simply throw a bunch of things. The order in which they come back depends on what you do in your query.

It may be possible to physically store the words in the sequence you want. But what happens if, for instance, you want to add more words later? You'd effectively have to create a whole new copy of the file with the new words inserted. And the order they come out would still depend on (A) the primary key if your table has one, and (B) the way you specify the query.

If you ask about this in the Access forum, I'm sure someone there could explain it better than I can.

That being said, if you really need to sort a bunch of words, one fairly simple method that has been used for many years is to add them all into a listbox control, with the Sorted property set to True. Of course, I don't know what version of VB you're using. This works up to VB6, at least.


P.S. Perhaps a database isn't appropriate for your purposes. You might find it simpler to store your data in a text file.

thank u for ur reply
but i want to ask about the up limit for the list count in vb6 list box
thank u

[QVeen72]

Hi,

ListBox can contain maximum of 32766 items..

Regards
Veena

[Killer42]

ListBox can contain maximum of 32766 items..

You may find that the practical limit is much lower, as things will slow down as you add more to the list. Try it, and see how it goes.