I am working out strategies for accessing SQL data from VFP. I'll be using business objects in my maintenance routines, but for reporting purposes, I intend on using SQL pass through.

My concern is if I have a typical statements in my code such as :
=SQLEXEC(nHandle1,"SELECT * FROM Table1")
=SQLEXEC(nHandle1,"SELECT * FROM Table2")

Then at some point later, I wish to move Table1 to a different SQL server. Hence a different connection handle needed for that table. Is there a strategy for handling this, _other_ then using stored procs or views as opposed to T-SQL statements in my SQLEXEC command?

TIA,
Anthony Letts