|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Query Analyzer won't let me edit grid data in 2000I looked at the help for possible reasons but this is not a lock, rights,
index, cluster, primary key, or SP4/version problem. I can't even do a "select * from authors" in pubs and have it be editable. Anyone have any ideas? The data grid from a SELECT statement has never been editable (is that a word? :-)).
OTOH, Object browser, right-click the table and "Open" is editable. -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "David Bienstock" <davidleebspam-sqlrs@yahoo.com> wrote in message news:3DA9AEC6-B13A-4AC6-9A7F-4B165D684B1C@microsoft.com... >I looked at the help for possible reasons but this is not a lock, rights, > index, cluster, primary key, or SP4/version problem. I can't even do a > "select * from authors" in pubs and have it be editable. > > Anyone have any ideas? Look up "Rules for Updating Results" in the help... it says it will
-- Show quote"Everyone knows something you don't know" "Tibor Karaszi" wrote: > The data grid from a SELECT statement has never been editable (is that a word? :-)). > > OTOH, Object browser, right-click the table and "Open" is editable. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > Blog: http://solidqualitylearning.com/blogs/tibor/ > > > "David Bienstock" <davidleebspam-sqlrs@yahoo.com> wrote in message > news:3DA9AEC6-B13A-4AC6-9A7F-4B165D684B1C@microsoft.com... > >I looked at the help for possible reasons but this is not a lock, rights, > > index, cluster, primary key, or SP4/version problem. I can't even do a > > "select * from authors" in pubs and have it be editable. > > > > Anyone have any ideas? > > > Look up "Rules for Updating Results" in the help... it says it will That part is for the Query Designer (available from inside EM), not query analyzer.-- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "David Bienstock" <davidleebspam-sqlrs@yahoo.com> wrote in message news:7AF462D0-46E6-4FEF-9002-3AC7E8B440D6@microsoft.com... > Look up "Rules for Updating Results" in the help... it says it will > -- > "Everyone knows something you don't know" > > > "Tibor Karaszi" wrote: > >> The data grid from a SELECT statement has never been editable (is that a word? :-)). >> >> OTOH, Object browser, right-click the table and "Open" is editable. >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://www.solidqualitylearning.com/ >> Blog: http://solidqualitylearning.com/blogs/tibor/ >> >> >> "David Bienstock" <davidleebspam-sqlrs@yahoo.com> wrote in message >> news:3DA9AEC6-B13A-4AC6-9A7F-4B165D684B1C@microsoft.com... >> >I looked at the help for possible reasons but this is not a lock, rights, >> > index, cluster, primary key, or SP4/version problem. I can't even do a >> > "select * from authors" in pubs and have it be editable. >> > >> > Anyone have any ideas? >> >> Tibor is correct. If you really read that section of BOL it states the
"Query Designer" not Query Analyzer. They are two completely different tools. -- Show quoteAndrew J. Kelly SQL MVP "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:e6l5IQYDGHA.2912@tk2msftngp13.phx.gbl... >> Look up "Rules for Updating Results" in the help... it says it will > > That part is for the Query Designer (available from inside EM), not query > analyzer. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > Blog: http://solidqualitylearning.com/blogs/tibor/ > > > "David Bienstock" <davidleebspam-sqlrs@yahoo.com> wrote in message > news:7AF462D0-46E6-4FEF-9002-3AC7E8B440D6@microsoft.com... >> Look up "Rules for Updating Results" in the help... it says it will >> -- >> "Everyone knows something you don't know" >> >> >> "Tibor Karaszi" wrote: >> >>> The data grid from a SELECT statement has never been editable (is that a >>> word? :-)). >>> >>> OTOH, Object browser, right-click the table and "Open" is editable. >>> >>> -- >>> Tibor Karaszi, SQL Server MVP >>> http://www.karaszi.com/sqlserver/default.asp >>> http://www.solidqualitylearning.com/ >>> Blog: http://solidqualitylearning.com/blogs/tibor/ >>> >>> >>> "David Bienstock" <davidleebspam-sqlrs@yahoo.com> wrote in message >>> news:3DA9AEC6-B13A-4AC6-9A7F-4B165D684B1C@microsoft.com... >>> >I looked at the help for possible reasons but this is not a lock, >>> >rights, >>> > index, cluster, primary key, or SP4/version problem. I can't even do >>> > a >>> > "select * from authors" in pubs and have it be editable. >>> > >>> > Anyone have any ideas? >>> >>> > > I looked at the help for possible reasons but this is not a lock, rights, Try a different tool?> index, cluster, primary key, or SP4/version problem. I can't even do a > "select * from authors" in pubs and have it be editable. > > Anyone have any ideas? I guess this is part of the reason why there's a third-party market for database developer tools... You might want to check out ours: www.upscene.com - Database Workbench -- Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com I'd rather go with a free tool that has row numbers, but thank you!
-- Show quote"Everyone knows something you don't know" "Martijn Tonies" wrote: > > I looked at the help for possible reasons but this is not a lock, rights, > > index, cluster, primary key, or SP4/version problem. I can't even do a > > "select * from authors" in pubs and have it be editable. > > > > Anyone have any ideas? > > Try a different tool? > > I guess this is part of the reason why there's a third-party market > for database developer tools... You might want to check out ours: > www.upscene.com - Database Workbench > > > -- > Martijn Tonies > Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL > Server > Upscene Productions > http://www.upscene.com > Database development questions? Check the forum! > http://www.databasedevelopmentforum.com > > > > I'd rather go with a free tool that has row numbers, but thank you! No offence, but row numbers don't mean a thing, do they, exceptfor - perhaps - displaying purposes. Anyway, if you're happy with Query Analyzer or any other tool, fine with us :-) I just wanted to point out that there _are_ (quite) some third-party tools with lots of different features and tricks... -- Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com  |
|||||||||||||||||||||||
Other interesting topics