ri kritzer [mailto:[EMAIL PROTECTED]
Sent: Fri 5/12/2006 10:01 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, n
s as to how to fix this so that I can order by any field I
> wish.
>
> Any input is greatly appreciated.
>
> Thanks,
> Travis Eland
>
>
>
> ________
>
> From: sheeri kritzer [mailto:[EMAIL PROTECTED]
> Sent: Thu 5/4/2006 4:15 PM
> To: Eland, Travis M.
> Cc: mysql@lists.m
: 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 it, and you're able to update the view?
ut is greatly appreciated.
Thanks,
Travis 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
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 pos
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
