Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 831
  • Last Modified:

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

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
FAWKE
Asked:
FAWKE
  • 2
  • 2
  • 2
2 Solutions
 
RichardCorrieCommented:
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
 
FAWKEAuthor Commented:
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
 
arbertCommented:
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
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
RichardCorrieCommented:
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
 
FAWKEAuthor Commented:
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
 
arbertCommented:
Make sure you have a valide Primary key on the table or Access won't let you edit it....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now