General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Idiot guide to using remote tables
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only