Hi Gerard

use the Foxpro DataExplorer
DO HOME() + "DataExplorer.app"

Make a connection to your SQL-Server
and drag and drop your SQL-Server table in a Foxpro Command Window.
That will give you a cursor on which you can do your commands.

Regards
Christoph Krapp


>Hi.
>I've been using Sql Server now for about 2-3 months and I miss the VFP command window terribly !!
>
>Anybobody know of any utility around whch emulates the VFP window in Dot Net, or even in VFP allows access to a Sql Server file using Command Window type commands.
>The likes of Brow fields , Delete all for a=b, replace all rep with "003" for State = 'NY' , Copy to ANOTHER Table for x=y etc etc etc
>Its very frustrating trying to do little tweaky changes like this..... I am currently taking a copy of the Sql Server off line, writing a special .prg in VFP to do any changes, and Restoring back the Database when finished.
>
>I thought I saw someting a while ago that did this sort of thing... I am aware of the VFP toolkit but I dont think it does this sort of thing.
>
>Any help appreciated.
>regards,
>Gerard