Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLStringConnect 'String is too long to fit'
Message
De
08/10/2005 03:37:29
 
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 8 SP1
Divers
Thread ID:
01057057
Message ID:
01057400
Vues:
18
Hi Wayne,
Such limits in vfp8 should be a bug ,i think. The best bet is to use VFP9 instead.Even if with vfp9,you also have to explicitly convert a string which length might be greater than 255 into a memory type field with CAST()in a SQL statement,eg.
CREATE CURSOR tmp(f1 c(10))
APPEND BLANK
SELECT REPLICATE('x',400) as col1 FROM tmp && raise the same error message as you mentioned
SELECT CAST(REPLICATE('x',400) as m) as col1 FROM tmp
Steven
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform