Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo fields for SQL database
Message
From
24/03/2011 12:16:47
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Memo fields for SQL database
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01504829
Message ID:
01504829
Views:
147
Hello,

Which field type and length is appropriate to use as VFP Memo field in MSSQL?

I created fields with type "text" and Fieldlength = 2^31-1, but when I query from VFP it does not return the field value, it shows blank.

In MySQL I used Mediumtext which works fine with memo fields.
Christian Isberner
Software Consultant
Next
Reply
Map
View

Click here to load this message in the networking platform