<html><head></head><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div id="yui_3_16_0_ym18_1_1458333328831_5049" dir="ltr"><span>[sorry top posted]</span></div><div id="yui_3_16_0_ym18_1_1458333328831_5049"><span><br></span></div><div id="yui_3_16_0_ym18_1_1458333328831_5049"><span>Thanks for those who responded. </span></div><div id="yui_3_16_0_ym18_1_1458333328831_5049"><span><br></span></div><div id="yui_3_16_0_ym18_1_1458333328831_5049" dir="ltr"><span>I should have stated that this would be a Windows not *nix appliaction.</span></div><div id="yui_3_16_0_ym18_1_1458333328831_5049" dir="ltr"><span><br></span></div><div id="yui_3_16_0_ym18_1_1458333328831_5049" dir="ltr"><span id="yui_3_16_0_ym18_1_1458333328831_5442">I do want to continue to do my processing in fp and not have to relearn the wheel in SQL. This Production shop mgt and scheduling software has been working fine for over 15 years. I have no problem working data back and forth with fileProODBC and SQL. However all that being said I think my best option will be to forego .NET and use either fpWeb for the screens and port the static data to SQL for use with devExpress.</span></div><div id="yui_3_16_0_ym18_1_1458333328831_5049" dir="ltr"><span><br></span></div><div id="yui_3_16_0_ym18_1_1458333328831_5049" dir="ltr"><span>Has anyone ever heard or seen devExpress tie to filePro directly? That would be the best option.</span></div><div id="yui_3_16_0_ym18_1_1458333328831_5049" dir="ltr"><span><br></span></div><div id="yui_3_16_0_ym18_1_1458333328831_5049" dir="ltr"><span>Thanks</span></div><div id="yui_3_16_0_ym18_1_1458333328831_5049" dir="ltr"><span>Rick Hane</span></div><div id="yui_3_16_0_ym18_1_1458333328831_5049" dir="ltr"><span><br></span></div> <div class="qtdSeparateBR" id="yui_3_16_0_ym18_1_1458333328831_4974"><br><br></div><div class="yahoo_quoted" id="yui_3_16_0_ym18_1_1458333328831_4931" style="display: block;"> <div style="font-family: HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_ym18_1_1458333328831_4930"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_ym18_1_1458333328831_4929"> <div dir="ltr" id="yui_3_16_0_ym18_1_1458333328831_4940"><font size="2" face="Arial"> On Friday, March 18, 2016 2:54 PM, Mike Schwartz via Filepro-list <filepro-list@lists.celestial.com> wrote:<br></font></div> <br><br> <div class="y_msg_container" id="yui_3_16_0_ym18_1_1458333328831_4928">> I know this might sound crazy but is anyone using SQL tables as a front end<br clear="none">> on filePro? I like the use of .Net screens and report writers like devExpress<br clear="none"><br clear="none">> Thank you in advance, Rick Hane, Yore Software Company<br clear="none"><br clear="none"> One way to read and write web data to filePro from .NET (or other) web applications is by configuring Apache Tomcat or something similar on your Unix (or Windows) server. <br clear="none"><br clear="none"> By using Tomcat, you are entirely using filePro processing tables to pass data to and from the filePro files and into your web applications.<br clear="none"><br clear="none"> The advantage of working entirely within filePro is that all the filePro indexes will stay properly updated and filePro data entry and posting rules will be obeyed.<br clear="none"><br clear="none"> The filepro processing called by Tomcat can be a little tedious to write. It has to be able to handle a lot of bad calls from the web app. For example, if a .NET developer requests info using an invoice number that does not exist, you have to make sure your code returns a message, something like, "That invoice number does not exist..." <br clear="none"><br clear="none"> You can pull large chunks of data back through Tomcat in order to populate SQL tables; preferably read-only SQL tables. For example, your web designer could send a tomcat request for all the invoice numbers and a little data from each invoice and then populate a temporary SQL table with it. You probably wouldn't want to pull back all the fully populated invoices for one customer and then try to load several SQL tables with the resulting data, because that would take several seconds (or minutes) to build in filePro, then transmit back and load into SQL files. <br clear="none"><br clear="none">Mike Schwartz<div class="yqt8429994815" id="yqtfd88746"><br clear="none"><br clear="none"><br clear="none"> <br clear="none"><br clear="none"> <br clear="none"><br clear="none"><br clear="none">_______________________________________________<br clear="none">Filepro-list mailing list<br clear="none"><a shape="rect" ymailto="mailto:Filepro-list@lists.celestial.com" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">Subscribe/Unsubscribe/Subscription Changes<br clear="none"><a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank" id="yui_3_16_0_ym18_1_1458333328831_5496">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br clear="none"></div><br><br></div> </div> </div> </div></div></body></html>