[RESOLVED] Database Problems

[Dbee]

I have a database that Has 72 records in it.

The database I created is sorted by name I created a sort routine for this.

Any way my problem is that now that I added the 72 record I get a return error on my files. I mean there out of sequence. If I do 71 then it is fine the min I add a record it screws up.

Any suggestion?

[Dbee]

I Was trying to extract file by using this but got screw up.

Record_Sets.Open "SELECT " & Table_Title(1) & " WHERE Num = '" & T & "' ORDER BY Num", Data_Connection(1), adOpenStatic, adLockReadOnly, adCmdText

[westconn1]

it is unnecessary to store records in any order, the only way to do it is to delete all records and readd in the sorted order,

as you can return a recordset by order on any field, i does it matter what order the records are in

[IanS]

SELECT * FROM SOME_TABLE_NAME ORDER BY SOME_FIELD_NAME

You can replace the * with required field names if you don't want all fields.

[Dbee]

Does this field name got to be a varible?

[Dbee]

I have alot of data that goes with the file and that is the reason for the file sort.

[westconn1]

Does this field name got to be a varible?

no, the name of the field you want sorted by, but it can be passed as a variable

I have alot of data that goes with the file and that is the reason for the file sort.

what does this mean? a lot of fields for the table or large amounts of data in fields

as ian pointed out you do not need to return all fields each time, but can just select the fields needed for a particular task

select name, address1, address2, state from customers order by state
(i think that is right, i have not done any database code for a while)
you can also return subsets of data using where
select name, address1, address2, state from customers order by state where pcode > 4999

72 records is a micro database, you could be working 72000 or more

[Dbee]

I figgered out how to extract the data field for the record.

My problem now is that the database is not returning the records as stored.
I use access to look at the data base and all file are in order.
but when I use the
RRR.MOVEFIRST
RRR.MOVE 1-1
Method of extracting then I get the error on certain records.

Blowing my mind.

[akhileshbc]

Post the code you are using, and the details of the error, and which line shows the error....

[IanS]

select name, address1, address2, state from customers order by state
(i think that is right, i have not done any database code for a while)

Yes, that is correct.

you can also return subsets of data using where
select name, address1, address2, state from customers order by state where pcode > 4999

I work with databases all the time but I'm having a 'blonde' moment but isn't it usual to but the WHERE statement before the ORDER BY

[westconn1]

I work with databases all the time but I'm having a 'blonde' moment but isn't it usual to but the WHERE statement before the ORDER BY

quite likely
from msdn

Syntax

SELECT fieldlist
FROM table
WHERE selectcriteria
[ORDER BY field1 [ASC | DESC ][, field2 [ASC | DESC ]][, ...]]]

[si_the_geek]

Duplicate threads merged - please post each question (or variation of it) only once. If you think you have posted in the wrong forum, PM a moderator to ask them to move it.