<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
filepro-list-bounces+gccconsulting=comcast.net@lists.celestial.com
[mailto:filepro-list-bounces+gccconsulting=comcast.net@lists.celestial.com] <b>On
Behalf Of </b>Richard Hane<br>
<b>Sent:</b> Friday, March 21, 2008 11:29 AM<br>
<b>To:</b> filepro-list@lists.celestial.com<br>
<b>Cc:</b> Rick Hane<br>
<b>Subject:</b> GUI Front Ends - the discussion<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<div>
<div>
<p class=MsoNormal>I would like to start this as a discussion thread. A couple
of ground rules. 1. No one is right and no one is wrong; we are all just
voicing our opinions. 2. Although my O/S of choice is Windows this certainly
can include *nix systems. Please let's not turn this in to a discussion
of operating systems.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>I have a couple of large projects coming up and have to make
some decisions. These are the same decisions I think many on this list
either have made or will be making in the near future. These new applications
will require a "GUI-like" front end for input, updates
and searches. Some MAY involve use over the web. However, that
is not an immediate requirement. Most important I want all processing to be
handled by filePro. We are currently using fpODBC 1.0.13 on 16 workstations
under Windows 2003.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>The question to be answered: What to use to create the GUI
front end?<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>1. Do we use another database program like MySQL, Miscrosft
SQL Server, Access, Oracle, etc.? If so, which one and why?<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>2. Or rather do we use a browser on an intranet initially
and maybe port to the web later?<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>3. If we use the browser what do we use; FPCGI, fpWeb, One
Gate, etc?<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>4. Or is fpGUI a possibility? What ever happened
to fpGUI? I own one of the first copies but you never hear anyone
discussing it.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>We are not concerned with output at this time as we have
decided to use (and we own) Print Wizard. Nice program Bob.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>OK, so there is our delema. Which way to go. We
really don't want to start down one path and the later turn around and
reinvent the wheel.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>I look forward to the thoughts of all you wise and noble
users of the fp.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Thank you in Advance,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Rick Hane,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Controller<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Deluxe Stitcher Company Inc<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><a href="http://www.deluxestitcher.com">www.deluxestitcher.com</a> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>773-777-6500<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Rick,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>If GUI like is adequate for you needs, then fpgui would probably
be a solution. Just remember that this solution id “GUI Like”
in putting the app in a window, adding mouse controls, etc. However your
window size is restricted.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Also, I have been told by fp support, that the app runs on the
server with the front end running on the workstation. This would require
with odbc and gui a fairly beefy server.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Although you can run your present application with no or few
modifications the run the basic fpgui, I would suggest the developer kit to
make full use of what is available. You are going to run into the license
manager when running fpgui. Although one of the nice things is you have a
more granular control of who access the application.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>The other “advantage” is you can have both the gui
and non gui versions running.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Ok so much for fp’s gui product. Going be based does
not necessarily mean going internet, it may mean intranet. There are a
number of tools out there which would allow you to accomplish this. I am
sure that other will chime in with suggestions.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>By the way, you should be able to download a demo version of the
latest version of fpgui from the fptech web-site. Not sure if the
developer’s tool kit is available this way. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Richard Kreiss<br>
GCC Consulting<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>rkreiss@gccconsulting.net<br>
</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> <o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
</body>
</html>