Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Varchar field in SQL
Message
From
17/07/1999 06:32:22
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Varchar field in SQL
Miscellaneous
Thread ID:
00242704
Message ID:
00242704
Views:
41
Hello, all.
My SQL server 7.0 database has a table with a field Varchar(2000). When i use VF 6.0 to get data by call SQLExec with SQL string has the fieldname in select list, i only get a memo field with len 255 (unexpected).
Later i try to resolve by issues 8 fields in select list by substring the varchar_field by 255 and in VF i add them together and fill in edit control. It work good in Windows 98 (total length is 2000), but in Windows NT, total length become 4930.
Can anyone help me to resolve this problem ?

Thank in advance.
Reply
Map
View

Click here to load this message in the networking platform