Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORDER BY Prevents Updateable Query

Status
Not open for further replies.
robulator

robulator

Programmer
Nov 17, 2000
33
US
It seems that when I open a recordset where the query (SELECT statement) contains an ORDER BY clause, the resulting recodset is not updatable regardless of how I try to set CurserType and LockType. Does anyone know a way around this?

Thanks, Rob
 
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Selection query : problem with 'ORDER BY'
Replies
4
Views
103
leifoet
leifoet
leifoet
  • Locked
  • Question
ASP Classic - SELECT query does not work
Replies
11
Views
254
guitarzan
guitarzan
leifoet
  • Locked
  • Question
How to compare dates in a SELECT query
Replies
12
Views
178
guitarzan
guitarzan
leifoet
  • Locked
  • Question
How do I save a list of the screen created with a select query
Replies
1
Views
75
ChrisHirst
ChrisHirst
leifoet
  • Locked
  • Question
Selection query - looking for the correct syntax
Replies
8
Views
132
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top