>In my remote view - I am having trouble updating SQLServer fields of "text" datatype if the data is longer than 255.
>I get an error message telling me to use the "Convert" function. I believe it is referring to an SQLServer function - can I do the equivalent somehow in VFP syntax or with SQL syntax somehow?
Yes that function is in T-SQL, you are getting an ODBC/SQL Server error. Like the memo fields in VFP, text fields in SQL server have to be handled a little differently. In SQL, you cannot have a char variable longer than 255 characters, thus, when it sends the SQL command via ODBC, it chokes. Just code it like you would a memo field, and you should be OK.
HTH,
Scot.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement