SQL 2005 and VFP memo fields

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SQL 2005 and VFP memo fields

Message

From

11/04/2010 11:10:28

Cetin Basoz
Engineerica Inc.
Izmir, Turkey

11/04/2010 03:43:18

Derek Chapman
United Kingdom

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: SQL 2005 and VFP memo fields

Environment versions

Visual FoxPro:

VFP 9 SP2

OS:

Windows 7

Network:

Windows 2003 Server

Database:

MS SQL Server

Application:

Desktop

Miscellaneous

Thread ID:

01459583

Message ID:

01459605

Views:

>Hi
>
>What's the best SQL Server field type to have in order to allow traditional memo field functionality within VFP, i.e. as in a free-text edit box? I have an updatable cursor within VFP, linked to the SQL Server table source.
>
>Regards

Varchar(max) or Varbinary(max) if may contain binary data.
Cetin

Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad

Map

View

Click here to load this message in the networking platform