General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL 'text' fields versus VFP 'memo' fields
I have upsized a VFP6 app (build w/ maxframe) to sql7. VFP memo fields have been defined as text fields by the upsize wizard in sql7. In sql, when i 'design table', the fields are text 16. When i generate sql script, the script shows them defined as text (w/ no length).
My remote view defs still have these fields defined as memos. When i add a new record via the app, the record is saved. What is strange is that after saving the record, i requery the remote view, restore the record pointer, and refresh the form. This works fine if i do not enter any text info into the memo fields. If i do, the requery apparently has problems because the form doesnt show the newly added record. If i close the form and refire it, i see the record. Again, if i leave the memo field empty, it works fine.
I changed the remote view def for these fields to char 250 and left them defined as text in sql (due to time constraints). This change has corrected the problem.
Can anyone shed some light on whats happening?
TIA
Next
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