>Hi all, >i am about to embark on my first project involving VFP6 and SQL Server. what i need to do is take the data within the SQL Server, present it for confirmation and upload it into an existing Foxpro database. i will also need to make sure that the SQL Server masterlists are current and update them from the foxpro tables as necessary. >in light of this, what is the best way to connect to the data? do i go through ADO? views? or some other method? any advice would be greately appreciated. >many thanks, >Jordan
Remote (parameterized) views may be the easiest way. Once you requery them they are basically VFP cursors that you can easily manipulate.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry