Text field is empty

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: EltonWang (elton_at_discussions.microsoft.com)
Date: 01/06/05 

Date: Thu, 6 Jan 2005 06:21:37 -0800

Hi,

Why do you think it's empty?
Normally, when you use SQL Server Enterprise Manager to
open a table with text field, it shows actual content when
it's <= 900 characters, but <Long Text> when it's > 900
characters. Actual content is in table. If you use Select
query in Query Analyzer, you can see the difference.

Hope it's helpful
Elton Wang
elton_wang@hotmail.com

>-----Original Message-----
>I'm trying to insert a record on an sql server database
table that has
>among others a text type field. The insert happens
without errors and
>all the fields show the correct information except for
the text field
>when the number of characters is larger than 900. In this
case the text
>field appears empty. If the text is less or equal to 900
characters
>they are inserted with no problem.
>
>In this case have a stored procedure with several input
variables
>including the text one and a asp.net page with a command
that is filled
>with the several parameters necessary to run the
procedure. One of them
>is the text parameter that is defined as follows:
>
>insertcommand.Parameters.Add(New SqlParameter("@texto",
SqlDbType.Text,
>2147483647))
>insertcommand.Parameters("@texto").Value = texto.Text
>Does someone knows what is causing this problem ?
>
>Thanks
>
>.
>

Relevant Pages

  • Re: Either BOF or EOF is true . . .
    ... >fetches a result set from a SQL Server table using a SELECT statement. ... >stored procedure accepts an input parameter, and may return an empty result ... My program doesn't care if it gets an empty ... I get an exception "Project Outlook.exe raised exception ...
    (borland.public.delphi.database.ado)
  • Either BOF or EOF is true . . .
    ... fetches a result set from a SQL Server table using a SELECT statement. ... stored procedure accepts an input parameter, and may return an empty result ... My program doesn't care if it gets an empty ... I get an exception "Project Outlook.exe raised exception ...
    (borland.public.delphi.database.ado)
  • Re: SQL Server + ADO = empty fields
    ... If I run the stored procedure in Query ... I'm using unbound forms and connecting to SQL Server via ADO. ... > I try to fill a recordset with the same stored procedure, ... > back as "empty". ...
    (microsoft.public.sqlserver.programming)
  • Re: grid updating and stored procedure
    ... > to update a single field in any of the rows. ... > It will be a simple field of 10 characters no more than that. ... and how do I get the change back to sql server? ... > have to use a stored procedure. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Stored proc with version number ?
    ... in addition to letter characters from other languages. ... Certain symbols at the beginning of an identifier have special meaning ... in SQL Server. ... I choose> the existing stored proc uspTableSave and right click Properties. ...
    (microsoft.public.sqlserver.programming)