I want to know what the best way is to insert data from VFP tables/cursors into SQL server tables. I am converting a program that was in VB/ADO to VFP. I am actually rewriting from the ground up. Mostly I am looking for others advice on whether to use SQLEXEC or ADO or ? in VFP. What is the best methodology to take full advantage of SQL server in VFP. For example of my concern if I use SQLEXEC to insert into a SQL table with an identity field, how do I get the identity record I just inserted without using a separate query.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.