Re: sql ntext field

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Charlie (Charlie_at_discussions.microsoft.com)
Date: 02/14/05 

Date: Mon, 14 Feb 2005 12:05:01 -0800

vfp 8
xp service pack 1
using cursor adapter
the field is defined as ntext
This is the only "memo" style information being passed to the SQL table.
Everything else is working fine.

"Rick Bean" wrote:

> Charlie,
> How is this field defined in the SQL database? What version and SP of VFP are you using? How are you "connecting"? Remote View, cursor Adapter, SQL Pass Through, ADO.
>
> Rick
>
> "Charlie" <Charlie@discussions.microsoft.com> wrote in message news:5437CE00-F1E6-4C68-9F13-C3D46F530C6D@microsoft.com...
> >I am using fox to connect to a remote sql database. When I populate the one
> > field with is an ntext field type the information gets cut off at 420
> > characters. Is there a reason or a solution to this?
>

Relevant Pages

  • Re: Recommendation for a datatype for replication
    ... I've not had any problems using ntext in replication scenarios. ... issues with an ntext column? ... someday when you move from SQL CE to SQL Mobile, ... If the length of the data is 255 characters or less; SQL Server CE ...
    (microsoft.public.sqlserver.ce)
  • RE: ntext column with 256 chars does not ger synch
    ... length greater than 255 characters. ... and a primary key cannot be created on an ntext column. ... I have also a pocket pc with SQL CE 2.0 with the same ... Everytime I sync and the data (SQL ...
    (microsoft.public.pocketpc.developer)
  • Re: Access managment in SQL
    ... > I have just imported my old access database into my new ... then ntext or text is what you want. ... The ncharrequires SQL Server reserve 4000 bytes for each row. ...
    (microsoft.public.sqlserver.clients)
  • EXCEPTION_ACCESS_VIOLATION using ntext
    ... I get the following error when i execute the SQL below. ... It works if the sp parameter is text rather than ntext or if the update uses ... @source int, ...
    (microsoft.public.sqlserver.server)
  • Re: ntext problem
    ... tables has a ntext data column. ... issue may have nothing to do with the ntext column at all. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)