Re: Modifying Data Directly through Studio Manager

Since this isn't the forum for business philosophy, I'll let that part go.
My real concern is the technology side of this.

That being said, I wish it was that easy, and I thought that is how it is
supposed to work. However, if I do as you say ("Edit a field, click or tab
to the next field."), I get an error. It's not one about data integrety per
say, but more a misnomer that "The updated row has changed or been deleted
since data was last retrieved."

I'm the only one in the table, or in the server for that matter. That leads
me to believe that I'm either missing something or, more likely, there is a
bug in the interface. I am running SP1 with all hot fixes made available
through Microsoft Update.

"Arnie Rowland" wrote:

Because business decision choose to allow this doesn't mean that it isn't an
troublesome decision, and in my opinion, one that is truly lunacy. It seems
like a 'Sales Add-on' (read: additional revenue) to provide an appropriate
'tool' to allow your customers to manage their data.

Yes, I've used it for editing. Edit a field, click or tab to the next field.
If an error occurs, correct the nature of the error (datalength, datatype,
etc.)

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Isaac" <Isaac@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:385F1137-8205-4600-96C5-FE885D779512@xxxxxxxxxxxxxxxx
Not idiotic, necessary. We won't refuse a sale because a customer is not
large enough to afford a DBA. A basic IT person could handle the
Enterprise
Manager, and our customers are entitled to do whatever they wish with
their
data.

I see the "Open Table" option. Have you tried to use it? I make a change,
click the pen to the left, and I get a red exclamation mark. If I execute
the query, the change is lost. If I hit enter (instead of clicking the
pen),
it errors out stating that the data has changed since the last refresh.

I've seen people comment on turned on the query pane, but all that does is
shows me the select statement. If my customers could do TSQL, I never
would
have made this post.

"Isaac" wrote:

HELP!!!! I've been using SQL for years, and I support a product built on
top
of SQL Server. Many of my customers are starting to upgrade to SQL 2005,
but
the ones that are not "SQL inclined" are having problems modifying data.
They are used to having simple tables that can have rows modified by
simply
opening Enterprise Manager (in SQL 7 and 2000), returning the appropriate
rows, entering the new data, and saving the record. From what I've seen
in
2005, you can't do that.

I understand that Query can be written, but this is for people that are
much
better with an "Access" environment, if you will. I've seen a lot of
posts
on this on other sites, but no solutions. Fellow MCSE's, I'm calling on
you
to help!!!

Thank you,

Isaac Shloss, MCSE



.

Relevant Pages

  • Re: OO vs. RDB challenge
    ... Lets say you have a list of customers ... Layer 1. ... SQL might help with Layer 1 ... SQL might help with Layer 2 but only if the query is simple enough. ...
    (comp.object)
  • Re: Modifying Data Directly through Studio Manager
    ... Because business decision choose to allow this doesn't mean that it isn't an ... 'tool' to allow your customers to manage their data. ... I've seen people comment on turned on the query pane, ... Many of my customers are starting to upgrade to SQL 2005, ...
    (microsoft.public.sqlserver.tools)
  • Re: LinqToSql Paging problem (bug?) with Skip and Take
    ... index as a default sort [assuming it can pick one from the numerous ... in a join query, I'll have to contend with unstable row order. ... reliable then they should really generate row-order preserving sql ... Sort customers on country, then page over customers ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: MS Query - Alias syntax
    ... In the graphics, ... query but for some reason the? ... I go thru the wizard and try to modify the sql. ... > FROM `C:\Tempo\nwnd4`.Customers Customers ...
    (microsoft.public.excel.worksheet.functions)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
Loading