>>Philip,
>>
>>Type is a VFP keyword (also a FPW keyword, but maybe it isn't as strict). That could be the issue. Try renaming it and see if that helps.
>>
>
>Hi Josh,
>
>Thanks for the input. Unfortunately, changing the TYPE word in the SQL statement to another made no difference.
>
>Phil

If you put < PRE > and < /PRE > around it (minus the spaces) it would be easier to read. I can't speak for anything else, but I know I couldn't find a syntax error in that mess. :)

-Michelle