filePro, and SQL

[Kenneth Brody]

On 10/23/2013 11:37 AM, Chris Sellitto wrote:
> filePro(r) 5.7.03
> Windows Server 2008
> Windows Workstations: WinXP, Win 7
>
> All,
>
> We are looking to take advantage of filePro(r)'s ODBC capabilities.  What
> we would like to know is if anyone has used filePro(r) to access SQL
> Server as its main database?  In other words, can you use filePro(r) to
> attach to an SQL database, thus eliminating the need for a KEY file?  All
> the while, keeping your filePro(r) code in tact?
>
> If this concept is doable, how difficult is it, and if someone out there
> has already had success with this, would they be willing to consult for
> us for a fee?
>
> I hope I explained it well enough.
>
> Any input would be greatly appreciated.

First, make sure that the SQL table has something that can be used like 
filePro's "record number".  Typically, this is an auto-increment numeric field.

Next, in define files, specify that you want to create an ODBC file.  Use 
the dialog boxes that come up to specify the ODBC data source.  filePro will 
then read the ODBC table definition and build a filePro map.

You can then use that file (almost) just like any filePro file.

There is also "low level" ODBC access, where everything is done in 
processing -- connect to the ODBC source, execute queries, read results, etc.

-- 
Kenneth Brody