How can I create a table in SQL from VFP and populate it from a cursor?





>Once you get passed the hump, it all gets pretty easy in VFP to access SQL*Server Data. Here is a quick example In its simplest form using a connectionstring (not the cursor adapter thing): (Note: I didn't test it, so there are probably errors in the text below!)
>
>******************************************************************
>strConnectionString = [Driver={SQL Server};Server=ServerNameHere;Database=YourDatabase;Uid=user_id;pwd=password]
>strSQL = "select * from Names where intPK = '1' " && or what ever sql statement you are passing.
>csrCursorToBeReturned ="csrNames"
>intHandle = SQLSTRINGCONNECT(strConnectionString)
>intResults = SQLEXEC(intHandle, strSQL, csrCursorToBeReturned)
>
>***************************************************************************************************
>You now have vfp cursor (csrNames) do play around with in pure VFP. ... and you can do updates and inserts and deletes the same basic way.
>
>Kevin