Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server 2000/2005 Syntax Clarification
Message
 
To
17/08/2006 08:54:39
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01146192
Message ID:
01146332
Views:
19
Tracy,

If it's SQL 2000, then you have a text field, but if it's SQL 2005, you should be using varchar(max) instead. Text is going away and varchar(max) is the replacement for MS SQL Server.

HTH,
Chad

>Update: Just noticed you created your cursor as a varchar type. We need to append to the end of a text data type field in sql server 2000/2005.
_________________________________
There are 2 types of people in the world:
    Those who need closure
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform