>>Hi John,
>>
>>Thanks for the reply..
>>Yes I am aware of the TYPE clause. What I was hoping for was a one liner
>>(a SET statement?) that would obviate the need for my having to search and alter any COPY statement or any process that modifies a table's structure. As the system is fairly large, I would like to avoid having to do this if possible.
>>
>>Ashley
>>
>Hmmmm....there seems to be no way out of that...you might want to change the source code and do a VERSION() call before any CREATE or COPY TO command and then issue the appropriate commands, ie:
>
>IF "Visual" $ VERSION()
> ** DO VFP commands
>ELSE
> ** DO FP 2.5
>ENDIF

John & Ashley,
If you try this, I think you will come across a problem compiling in 2.5 where it hits the TYPE FOX2X clause - it won't like it. Keep the 2.5 and 5.0 apart! Check the version at start and reject program if necessary.