fpODBC to SQL question

[Kenneth Brody]

On 1/20/2010 12:34 PM, Richard Hane wrote:
> For years I have been updating our plant mgt apps in fileProODBC using Excell spreadsheets.  Th Excell sheets have a link to our ERP databases written in Microsoft SQL Server.  Each night I update 9 spreadsheets and run a batch file that updates filePro. Since I will be retiring in the near future I need to make this function simpler.  The answer would seem to be to use the ODBC portion of fp.
>
> My question is rather basic.  Which method High Level or Low Level (as listed in fp) would I need to use.  Note I am not writing data back to SQL only reading data and updating fp.

High-level can be "easier" for a filePro developer, since it presents the 
ODBC file as just another non-filePro file.  However, you might have to 
tweak the file structure (making sure that there exists a field which can be 
used as a record number equivalent), and some other restrictions on 
accessing the file.

Low-level has less layers of abstraction, and can be more efficient. 
However, you have to know SQL, and you need to manage the query, cursor, and 
field access directly.

Since you appear to only need the access in a batch import type process, I 
would recommend looking into using low-level.

-- 
Kenneth Brody