I have run into the problem of my varchar(255) - (SQL Server 7.0 Back-end) fields not being large enough to accomodate the necessary text.
In the VFP app I created to access the SQL Server back-end, I originally made no use of memo fields, since I made sure all SQL fields were 255 characters or smaller.
I have now gone in and expanded some of the SQL fields to be greater than 255 characters. In order for my FoxPro app to recognize these changes, I removed the remote views associated with the changed tables, and re-created them, in the hopes that the table changes would be reconized by the new remote views.
For most of the forms containing thses remote views, my plan worked, and I can enter more than 255 characters in the textboxes for these fields. I can save the data, close the app and re-open it, finding that my app is in fact, saving and recognizing the expanded field size.
I do have one form though that is acting odd. I can view the data in one of the fields that I increased the field size, but as soon as I edit that field in any way, I am unable to close the form.
Two questions I have are:
1.) Any ideas as to why the finicky form won't close?
2.) Am I going to run into additional problems down the road associated with SQL Server varchar fields being recognized by my FoxPro app as memo fields? ( I opened a browse window while running one of the forms with expanded fields and Foxpro had determined it to be a memo field)
Thanks for your time and suggestions!