473,394 Members | 1,750 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Ntext limitations??

bwesenberg
Hello,
I am having and issue with an ntext field. It seems to have a limitation on it.
Here is the history.

I am supporting a database that was created by a prior employee and I am now having some issues.
I have a MS Access front end connected to SQL back end. Connected through ODBC.

The filed is called [Comments] the data type on the SQL table is ntext. The field is located on [Table1].

The main issues is: the comments will not print in full. (however I have found other issues with this as well - see below)

There is a record that has a very large amount of text in the [Comments] field.
There is steps the users have to go through to add text to the [Comments] field.
There is a button on the main form that says [Add Comments] What happens there is a unbound form comes up with the claim number filled in and a blank area to type your text.
Then on the unbound form there is a button that says [Enter Comments]. What happens there is the current date and time with a new line is added to the [Comments] field on table with the text that was enterd into the unbound form.
The new text is put at the beginning of the field. I can use that method to add more commments.

What normally happens is the user will want to print their comments with the [Print Comments] button. What that does is just brings up a report with the comments in them. However with this record, it is cutting off the first 8 days of comments. (which is the first 8 entries of the comments field)

The other issues is when I went into the table to delete the "test" comments it tells me "the text is too long to be edited.
I also tried to modify the text directly in the SQL table and it does not show the comments in that field it just says <Long Text>.

Can anyone assist me with this issue?
Jul 27 '07 #1
3 2554
Can anyone give me any ideas at all even what to start looking at?
Aug 20 '07 #2
TAZdba
5
I'm waiting for the answer to this one too!
Oct 8 '07 #3
Shashi Sadasivan
1,435 Expert 1GB
Have you had a look at msdn regarding this?

cheers
Oct 8 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: tony | last post by:
I changed the datatype of a field in a SQL Server 2000 database from nvarchar to ntext, but now nothing is being displayed. The "Body" column of the datatable used to be nvarchar(8000) and the...
0
by: Tom | last post by:
Hi, I've got problems using ntext data in a stored procedure (SQL-Server 2000): create procedure testproc @xmldata ntext as declare @Param ntext
3
by: Matik | last post by:
Hello to all, Below the sample code: declare @arg_szMsgText ntext set @arg_szMsgText = isnull(@arg_szMsgText, N'unknown message') Now the error message I get: "The assignment operator...
7
by: Oleg Ogurok | last post by:
Hi all, I need to store data into about 104 columns. This is problematic with MS SQL, since it doesn't support rows over 8kb in total size. Most of the columns are of type NVARCHAR(255), which...
1
by: Derek Erb | last post by:
SQL Server 2000 : I have a series of tables which all have the same structure. When any of these tables are modified I need to syncrhonise all of those modifications with one other table wich is a...
2
by: Sileesh | last post by:
HI I know this is not the right forum to post this question, but i think some one might have a suggestion. I have a Table "Test" with columns Id bigint (PK), Number Varchar(50), Notes ntext....
2
by: Igor | last post by:
Is there a way to transfer ntext data from one table to another? I tried this UPDATE SET = (SELECT FROM WHERE =1) WHERE = 1;
3
by: =?Utf-8?B?ZGF2aWQ=?= | last post by:
I try to follow Steve's paper to build a database, and store a small text file into SQL Server database and retrieve it later. Only difference between my table and Steve's table is that I use NTEXT...
2
by: verb13 | last post by:
I am running this query to an sql server 2000 database from my asp code: "select * from MyTable where MySqlServerRemoveStressFunction(MyNtextColumn) = '" & MyAdoRemoveStressFunction(MyString) &...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.