Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Text/varchar
Message
De
16/06/1998 13:18:42
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Divers
Thread ID:
00108745
Message ID:
00108751
Vues:
48
Hi Marcelo...

>I executed a "sqlexec" command to get a table from SQL-Server.
>When I changed the value of a memo field (text in SQL) that have more than 255 chars, and tried to go to another record, it returned this error:
>
>[Implicit conversion from datatype 'text' to 'varchar' is not allowed. Use the CONVERT function to run this query.]
>
>Does someone knows how can I do to fix it ??
>

The source table in SQL Server has that column defined as VARCHAR, which can only be up to 255 characters in length. You either have to limit the amount of entry on the front-end, or ALTER TABLE the SQL Server table and change that column into the TEXT type.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform