What is your SQL Server field type (is it a text field or a varchar?)
Is it, for instance, a varchar(255) in SQL Server, that VFP sees as a memo field ?
It can handle a varchar(254) as a character field.
I would say, if the above is the case, avoid varchar(255) and use varchar(254).
varchar(255) is a special case, (or mappings of varchars to memo fields) because I think the ODBC driver assumes a VFP memo field is a text field on SQL Server when it isn't and is using the WRITETEXT functions of SQL Server.
>I change a table in 6.5 and i changed the views in FoxPro to show the new chnages in the table i changed.
>
>I can add records but when i go to edit the record i get this message after a save click.
>
>Implicit Conversion From Datatype "Text" to "VarChar" is not allowed use the convert function to run this query.
>
>I checked all the fields in SQL 6.5 they match the way i created the table.
>
>I checked the view in FoxPro and the files were the same except for the naming of "Text" in SQl is equal to "Memo" in FoxPro.
>
>Can anyone please help
>
>Shawn
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only