You can pretty much do any SQL Server commands via the SQLEXEC() function in VFP....Using MS SQL Server 6.5 by Que is a good book for a general reference of SQL Server commands.
>Is there a list any where of the MS SQL Server commands. Like Insert and Update and Delete? And how about Skip and Seek? I would like to see how this stuff is done in foxpro. I can get connected add tables add databases but thats about it.
>
>Charles
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05