PM
To: Eland, Travis M.
Cc: mysql@lists.mysql.com
Subject: Re: ORDER BY making recordset non-updatable
Maybe I'm thick
You have a view, called vwMyView.
You SELECT rows from it, and you're able to update the view?
Yet when you SELECT with an ORDER BY clause, you're not allowed to
update
PROTECTED]
Sent: Thu 5/4/2006 4:15 PM
To: Eland, Travis M.
Cc: mysql@lists.mysql.com
Subject: Re: ORDER BY making recordset non-updatable
Maybe I'm thick
You have a view, called vwMyView.
You SELECT rows from it, and you're able to update the view?
Yet when you SELECT with an ORDER
AM
To: Eland, Travis M.
Cc: mysql@lists.mysql.com
Subject: Re: ORDER BY making recordset non-updatable
That's a problem with SQL Server -- google search on your error and
you'll see that that's associated with SQL server, not MySQL.
-Sheeri
On 5/11/06, Eland, Travis M. [EMAIL PROTECTED] wrote
Eland
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Thu 5/4/2006 4:15 PM
To: Eland, Travis M.
Cc: mysql@lists.mysql.com
Subject: Re: ORDER BY making recordset non-updatable
Maybe I'm thick
You have a view, called vwMyView.
You SELECT rows from
Maybe I'm thick
You have a view, called vwMyView.
You SELECT rows from it, and you're able to update the view?
Yet when you SELECT with an ORDER BY clause, you're not allowed to
update the view?
I just do not understand how a read statement affects DML. I think
you're going to have to
Heya.
I am in the process of modifying a program to access data from a MySQL database
instead of a SQL Server database. I have a view that is referenced as follows
(through use of a data environment command):
Select * from vwMyView where id = ?
If I run this command, I get the data that I