OK, I've managed to set up a table on SQL server 2000
I've managed to create a dsn and connect to it both inside and outside vfp. Using SQL Enterprise Manager, I can go in and import, delete query and all that good stuff. But I can't figure out how to do that sort of thing using vfp code.

I can connect using an sqlconnectstring and I can retrieve a list of tables using the sqltables command. I can see my table in there.

But I can't figure out how to do anything with it!

Can someone give me an example of syntax which would let me search it, add to it, delete a record or a bunch of records etc etc.

Thanks

Harry