General information
Category:
Coding, syntax & commands
I have 4 memo fields: Dispatchers Notes, Technician Notes, Billing Notes, and Parts Notes.Most of these are empty most of the time. Ocasionally, there will be a note in one or two and very rarely in all four.
I have a function that takes all four memo fields and returns:
Dispatcher: + Dispatches Notes
Technician: Technician Notes
Billing: Billing Notes
Parts: Parts Notes
When I use the function as a field parameter for a SQL Select, I sooner or later get a "string is too long to fit" error.
If the Select were trying to put the results of the function call into a memo field, it wouldn't be a problem but, it is clearly attempting to put it into a characte field.
Is there any way around this problem in VFP 7.0?
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