>When connecting to our SQL database using a remote VFP view, we get an error: DataType property for field 'SpecialInstructions' is invalid. 'SpecialInstructions' is a SQL ntext field.
>
>What do we need to do to convert this in the remote view to a VFP memo fields so that we can view it? TIA.
I define all my views in code, by first designing the view in the view designer, then using GenView.prg (I think Erik Moore wrote this utility). After the view is created in code, I can change SQL Server DateTime columns to date by sepcifying:
DBSetProp('rv_Company.MyDateField', 'Field', 'DataType', "D")
You may be able to use the same principal for the memo field:
DBSetProp('rv_Company.MyMemoField', 'Field', 'DataType', "M")
Chris McCandless
Red Sky Software