Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo fields for SQL database
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
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:
01504846
Views:
60
>>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.
>
>
>How is set property FetchMemo of cursor?
>
>?CURSORGETPROP("FetchMemo",0)
>?CURSORGETPROP("FetchMemo",ALIAS())
>
>
>MartinaJ

Both return .T.
Christian Isberner
Software Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform