|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Edit data with Query AnalyzerIs there any way I can use Query Analyzer to edit data in a table via a
graphic grid, i.e. actually changing individual values in cells? Using SQL statements is too cumbersome for my purpose; I need to have more hands-on control. Rick,
Use the Object Browser (F8) --> right-click table --> Open. HTH Jerry Show quote "Rick Charnes" <rickxyz--nospam.zyxcharnes@thehartford.com> wrote in message news:MPG.1dc1e9977390b6f9989901@msnews.microsoft.com... > Is there any way I can use Query Analyzer to edit data in a table via a > graphic grid, i.e. actually changing individual values in cells? Using > SQL statements is too cumbersome for my purpose; I need to have more > hands-on control. Rick Charnes wrote:
> Is there any way I can use Query Analyzer to edit data in a table via Some tables yes and some tables no. I've never figures out why. I would > a graphic grid, i.e. actually changing individual values in cells? > Using SQL statements is too cumbersome for my purpose; I need to have > more hands-on control. use SQL Enterprise Manager instead if you absolutely have to edit the data in a table in this fashion. I will give another solution, you can actually do everything you want to
manually. even queries can be developed using that... wondering what is it.. it is around every one but rarely people use that is access adp. More so, you can develop forms/ and reports from sql server data with ease. follow these simple steps, 1.open access(better xp or above) 2.select new 3.select new project from exisiting data in the side pane( by this select adp project not mdb) 4.data link dialogue appears, fill credentials and connection details 5.Rest is the world that you wont imagine -- Show quoteRegards R.D --Knowledge gets doubled when shared "David Gugick" wrote: > Rick Charnes wrote: > > Is there any way I can use Query Analyzer to edit data in a table via > > a graphic grid, i.e. actually changing individual values in cells? > > Using SQL statements is too cumbersome for my purpose; I need to have > > more hands-on control. > > Some tables yes and some tables no. I've never figures out why. I would > use SQL Enterprise Manager instead if you absolutely have to edit the > data in a table in this fashion. > > -- > David Gugick > Quest Software > www.imceda.com > www.quest.com > > > Some tables yes and some tables no. I've never figures out why. I always thought it is depending on whether the table has a PK, UQ, unique index or not.-- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "David Gugick" <david.gugick-nospam@quest.com> wrote in message news:eIQsIpc1FHA.3520@TK2MSFTNGP10.phx.gbl... > Rick Charnes wrote: >> Is there any way I can use Query Analyzer to edit data in a table via >> a graphic grid, i.e. actually changing individual values in cells? >> Using SQL statements is too cumbersome for my purpose; I need to have >> more hands-on control. > > Some tables yes and some tables no. I've never figures out why. I would use SQL Enterprise Manager > instead if you absolutely have to edit the data in a table in this fashion. > > -- > David Gugick > Quest Software > www.imceda.com > www.quest.com Tibor Karaszi wrote:
>> Some tables yes and some tables no. I've never figures out why. That's probably the case.> > I always thought it is depending on whether the table has a PK, UQ, > unique index or not. David Gugick wrote:
> Rick Charnes wrote: I've noticed that tables with no unique constraint of any>> Is there any way I can use Query Analyzer to edit data in a table via >> a graphic grid, i.e. actually changing individual values in cells? >> Using SQL statements is too cumbersome for my purpose; I need to have >> more hands-on control. > > Some tables yes and some tables no. I've never figures out why. kind appear as read-only, but once you add a primary key for example, you are able to modify data. If QA front end is written in MFC, then it is probably related to the behavior of MFC recordset, which is also read-only after pulling data from such a table. Enterprise manager can do that, although I would not do it except when
creating a database for a non-live project. All data manipulation needs to be done through applications such as databrowsers and so on. Show quote "Rick Charnes" <rickxyz--nospam.zyxcharnes@thehartford.com> wrote in message news:MPG.1dc1e9977390b6f9989901@msnews.microsoft.com... > Is there any way I can use Query Analyzer to edit data in a table via a > graphic grid, i.e. actually changing individual values in cells? Using > SQL statements is too cumbersome for my purpose; I need to have more > hands-on control.  |
|||||||||||||||||||||||
Other interesting topics