Re: Modifying Data Directly through Studio Manager

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
    ... '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, ... Isaac Shloss, MCSE ...
    (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: Foxpro sql limitations
    ... My application is an online user interface for customers to log on to ... and check the status of their fleet of vehicles (the client is a fleet ... The ASP site connects to the Foxpro database used ... This SQL db has since been expanded to include some more ...
    (microsoft.public.fox.vfp.queries-sql)
Loading