General information
Category:
Coding, syntax & commands
Hullo Jim - if you have access to the SQL Server why not [pick one]
1. write a DTS then call it from VFP that will get the data natively IN SQL SERVER into a fox table.
2. use SPT code and make a cursor, then do what ever you want from there.
3. make a remote view ....
4. make an ascii dump of the sql table, then import it into vfp.
any one of those should work for you - personally i prefer #1 when dealing with large data sets, and #2 when dealing with small data sets. I only use #4 when there is some security issue and I have to do offline analysis cause some bonehead dba doesn't understand concept of sql connections.
hth - mondo regards [Bill]
ps - Assuming MS SQL HERE - but #2 works for Oracle, mySql, PostGreSql, FireBird, etc etc.
Previous
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