Record 59 it is shown in first row

[mi1306]

Hi,

At me has arisen such problems:
I work with Access database. In the form I have DataGrid connected with Query in DB and I use DataEnvironment.
In DB everything is all right, but in DBGrid record with ID 59 shows on the first place and all is confused.
Obviously it and in Recordset.
Who that has idea what to occur?

Miho

 

[Golom]

Presumably you are populating your data grid from a recordset and that recordset is generated from some SQL. You should note that, without an ORDER BY clause, SQL does not guarantee any particular ordering for the returned records. Build an ORDER BY clause for the fields that you want and your record 59 should return to its proper place.

 

[mi1306]

I do not work with SQL. Where to put ORDER BY clause?

Miho

 

[Swi]

http://www.1keydata.com/sql/sql.html

Swi

 

[Golom]

mi1306

Trust me. If you're working with Access then you're working with SQL.

The "Query in DB" to which you refer is written in SQL. Go to "Queries" in Access; find the one that is being used to populate your datagrid and open it in design view. Each field that is in the query appears in the design grid. In the "Sort" box below each field that you want sorted, select "ASC" or "DESC" for ascending oe descending sort order and then save the query.

 

[mi1306]

Thank ALL

Very much have helped me.

MIHO