Solved

Edit a ntext <Long Text> field/record in a table. easily!

Posted on 2004-04-22
6
801 Views
Last Modified: 2012-05-04
Hi there,

I have taken over a SQL 2000 database and within it is a table which has
content for ASP web pages.
Some of the content is pretty long, and for some reason is displayed as
<Long Text> in the table, up returning all rows.
This particular field is ntext.

I need to change this text, how can i do this by ammending the existing
text? I need to see what is there!
I have tried to look into this and there is no "simple" way to do this!!!

HELP!, and be gentle, i am new to SQL and need to be spoon fed a tad ;-)

Hope you guys can help,

Thanx
0
Comment
Question by:FAWKE
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 10

Assisted Solution

by:RichardCorrie
RichardCorrie earned 45 total points
ID: 10887736
when you say ><Long Text> in the table, up returning all rows > is this in the view from SQL manager or the result given in an ASP page?

you can only edit a nText field trough SQL statements; you cannot amend using the native SQL Enterprise manager table view.

The quick solution is to knock up an MS Access ADP project, connect to your SQL db an then create a form over the table that you want to edit - done in 15mins!!

Richard
0
 
LVL 2

Author Comment

by:FAWKE
ID: 10888434
ok, so if i create an Access Db, with link tables to my SQL db, and create a form that edits this?
I am not a confident developer, so what might take you 15mins will take me 60mins ;-)

This is the view i get for SOME records in a column, in the SQL enterprise manager,,,,,

Il give that a go,

Any other ideas??
0
 
LVL 34

Accepted Solution

by:
arbert earned 30 total points
ID: 10888484
You can't edit a text field in Enterprise Manager over 1023bytes.....

You wouldn't have to build a form in access, just link the tables and open the table in Access...
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 10

Expert Comment

by:RichardCorrie
ID: 10888521
when you start Access 2000 you can create a new Project... this will take you to a wizard that will create the links etc to your db.

You can then edit the table directly (as per FAWKE's recomendation) or create a form over the table.


Richard

0
 
LVL 2

Author Comment

by:FAWKE
ID: 10888548
wicked, well thanks guys.... all sorted, im gonna make the changes and issue the points,

Thanx again.. what a good job you guys do...
0
 
LVL 34

Expert Comment

by:arbert
ID: 10888696
Make sure you have a valide Primary key on the table or Access won't let you edit it....
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question