Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server 2000/2005 Syntax Clarification
Message
 
À
17/08/2006 08:54:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01146192
Message ID:
01146332
Vues:
18
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform