Hi Rixon,
That syntax won't work with VFP versions prior to 8. In earlier versions you'll need to break it up.
Regards,
Liam
>I'm trying to get the following SQL code to work in VFP:
>
>INSERT INTO employee (EmpNo, LastName, FirstName,
> PhoneExt, HireDate, Salary)
> SELECT EmpNo + 200, LastName, FirstName,'000',
> HireDate, Salary + 1000
> FROM empins
>
>Evidently VFP uses different syntax than SQL server or it simply can't insert data based on the results of a select statement.
>
>Any help would be appreciated. Thanks.
Liam O'Hagan
MCP VFP Desktop Apps