>The following code causes error "error building sort key" in VFP 9 beta
>but works in previous versions.
>There is NO description about this error in help file.
>
>How to fix this ?
Hi Andrus,
You can try a couple of things:
- Turn off new query bechavior for variable size calculated character columns by issuing
SET VARCHARMAPPING OFF
- Use CAST() function to control type and size of calculated fields.
--sb--