<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span><< Sorry top posted >></span></div><div><span></span> </div><div><span>Hi Ken,</span></div><div><span></span> </div><div><span>Let me take this concept a little deeper. I do a lot of pulling of SQL data each night in to our filePro DB. That works better than I ever hoped for. All is done low level.</span></div><div><span></span> </div><div><span>Let's assume I have a couple of files in filePro that contain customer notes. And from with in my MRP software in the Customer Tables I would like to be able to call up and view this data. Could I create a matching SQL Table? Yes I know about the record number field being required. Then either read the data in to the table from filePro as requested via a lookup or just propigate the SQL Table with the filePro
data and leave it as an SQL Table.</span></div><div><span></span> </div><div><span>Thank you,</span></div><div><span>Rick Hane</span></div><div><span>Controller</span></div><div><span>Deluxe Stitcher Company Inc</span></div><div><span>ISP Bindery & Stitching Products</span></div><div><span><a href="http://www.deluxestitcher.com/">http://www.deluxestitcher.com/</a></span></div><div><span><var id="yui-ie-cursor"></var></span> </div><div> </div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <div style="margin: 5px 0px; padding: 0px; border: 1px solid rgb(204, 204, 204); height: 0px; line-height: 0; font-size: 0px;" class="hr" contentEditable="false" readonly="true"></div> <font size="2" face="Arial"> <b><span style="font-weight: bold;">From:</span></b> Kenneth Brody <kenbrody@spamcop.net><br>
<b><span style="font-weight: bold;">To:</span></b> Chris Sellitto <sellich@guaranteedreturns.com>; "filepro-list@lists.celestial.com" <filepro-list@lists.celestial.com> <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday, October 23, 2013 10:47 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: filePro, and SQL<br> </font> </div> <div class="y_msg_container"><br>
On 10/23/2013 11:37 AM, Chris Sellitto wrote:<br>> filePro(r) 5.7.03<br>> Windows Server 2008<br>> Windows Workstations: WinXP, Win 7<br>><br>> All,<br>><br>> We are looking to take advantage of filePro(r)'s ODBC capabilities. What<br>> we would like to know is if anyone has used filePro(r) to access SQL<br>> Server as its main database? In other words, can you use filePro(r) to<br>> attach to an SQL database, thus eliminating the need for a KEY file? All<br>> the while, keeping your filePro(r) code in tact?<br>><br>> If this concept is doable, how difficult is it, and if someone out there<br>> has already had success with this, would they be willing to consult for<br>> us for a fee?<br>><br>> I hope I explained it well enough.<br>><br>> Any input would be greatly appreciated.<br><br>First, make sure that the SQL table has something that can be used like <br>filePro's "record
number". Typically, this is an auto-increment numeric field.<br><br>Next, in define files, specify that you want to create an ODBC file. Use <br>the dialog boxes that come up to specify the ODBC data source. filePro will <br>then read the ODBC table definition and build a filePro map.<br><br>You can then use that file (almost) just like any filePro file.<br><br>There is also "low level" ODBC access, where everything is done in <br>processing -- connect to the ODBC source, execute queries, read results, etc.<br><br>-- <br>Kenneth Brody<br>_______________________________________________<br>Filepro-list mailing list<br><a href="mailto:Filepro-list@lists.celestial.com" ymailto="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>Subscribe/Unsubscribe/Subscription Changes<br>http://mailman.celestial.com/mailman/listinfo/filepro-list<br><br><br></div> </div> </div> </div></body></html>