Insert record between two records and datediff for the partiuclar feilds

  • Thread starter Thread starter Raashid
  • Start date Start date
R

Raashid

Hi,
Please help me about the Insert one records between two
records and i need datediffrent from one table diffrent
category. means diffrent conditions.
Reagrds
Raashid
 
Hi,

We technically do no insert record "between" other records.

In a table, the record are NOT ordered (if they are, it is by order of
the value of their primary key, when there is one).

In a record_SET, the ORDER BY clause define the order in which the
initial records are "linked" (for moveNext and movePrevious). If there is no
ORDER BY clause in the SQL statement used to fill the recordset, the order
is the one the database engine "through out" the records, accordingly to the
query plan it decided to use, at the moment. New records are append (to the
end), and if you want to reshuffle the records accordingly to the order by,
after having appended records, you can try a requery.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top