<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi<br>
<br>
I have been following your project :)<br>
<br>
<div class="moz-signature">
<div class="Section1">
<p class="MsoNormal"><span style="" lang="EN-NZ"><o:p>Personally I
would NOT try and use the same physical DB for a Win / local app and a
web app. You lose lots of the benefits of a local / win app if you do
this (i.e. Speed, reliability, availability). <br>
</o:p></span></p>
<p class="MsoNormal"><span style="" lang="EN-NZ"><o:p><br>
If I understand your current situation I would recommend the
following. Setup a MySQL web DB (because all isps seem to support it)
build a simple web app using the technology of your choice (PHP would
be a good option) to add orders to the DB. Build a small Delphi app
locally that keeps the product information on the web DB up to date and
downloads any new orders from your web DB into the local dbase Db. So
you have two things to build <br>
1. A web site / ordering system<br>
2. A transfer app to transfer data to and from the web DB. This step
was what I referred to in my previous email.<br>
</o:p></span></p>
<p class="MsoNormal"><span style="" lang="EN-NZ"><o:p><br>
my answers to your # questions<br>
</o:p></span></p>
<p class="MsoNormal"><span style="" lang="EN-NZ"><o:p><br>
1. Yes, you know Delphi so thats one less thing to learn.<br>
2. dBase is crud. You should upgrade to a relational / SQL DB. That
said, its lots of work and you don't need to do it for the current
issue.<br>
3. Yes. There are lots of options. The one above is simple.<br>
4. Not required for task. Good idea to.<br>
5. Don't know about it. <br>
6. MySQL because its free for web sites and ISPs love it. SQL server
because MS shops love it and get it cheap / promote it and it makes
marketting people happy. ISPs might like to charge you a fee to host
MS SQL server so that makes them happy too :) . SQL Server is good,
fast and generally better than MySQL. I like Firebird DB :)<br>
</o:p></span></p>
<p class="MsoNormal"><span style="" lang="EN-NZ"><o:p>7. Thats nice :)
you could make your web site using that if you want !</o:p></span></p>
<p class="MsoNormal"><span style="" lang="EN-NZ"><o:p><br>
Cheers<br>
Rob<br>
</o:p></span></p>
<p class="MsoNormal"><span style="" lang="EN-NZ"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(255, 153, 0);" lang="EN-NZ"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="" lang="EN-NZ"><o:p> </o:p></span></p>
</div>
</div>
<br>
<br>
Charlie wrote:
<blockquote cite="mid:00f901ca2f3e$721d96a0$5658c3e0$@net" type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;}
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;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle20
{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;}
/* List Definitions */
@list l0
{mso-list-id:577446001;
mso-list-type:hybrid;
mso-list-template-ids:-442600206 -728056484 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;}
@list l1
{mso-list-id:587547186;
mso-list-type:hybrid;
mso-list-template-ids:335587680 67698705 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</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]-->
<div class="Section1">
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Rob,
thanks so much for the
reply. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">I’ve been
told that it is
possible to have the internal local application (Win32 application) and
the web
application accessing the same database which resides on the website by
using
web services. This prompted my question about Web Services and Clients.
I have
no idea if this is practical, doable or even a wise thing to do. Since
I am a
intermediate Delphi programmer and since the application is for my only
client
and since hosting on a Windows web server is no problem, I would
sincerely appreciate
any advice.</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Can I ask
you another question.
Or a couple?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Presently
I’m using BDS
2006, InfoPower Suite 2007, AceReporter and dBase. The original
application was
Accounting for Delphi (ColumbuSoft). I’ve modified the original
application extensively because of the ‘business’ rules. I use
TTables, TQueries & TDataSets and data aware components
extensively. The
application is on a WinXP Pro peer-to-peer network and is encountering
speed
issues. Essentially the application is an order/entry application which
also
creates manufacturing documents which the plant employees use to create
the
items ordered. Additionally it exports to QuickBooks an invoice for the
order. I
really want for the customers to be able to enter their own orders as
opposed
to faxing or emailing them. Hence my interest in a web application.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Any
course of action will
require a huge learning curve for me. My only source of help is forums
like
this. Given this<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 0.75in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="color: rgb(31, 73, 125);"><span style="">1)<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);">Should I continue
with Delphi<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 0.75in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="color: rgb(31, 73, 125);"><span style="">2)<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);">and dBase<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 0.75in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="color: rgb(31, 73, 125);"><span style="">3)<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);">Are there better
ways than web services to allow customers to enter their own orders<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 0.75in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="color: rgb(31, 73, 125);"><span style="">4)<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);">If I continue with
Delphi should I upgrade to RAD Studio 2010<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 0.75in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="color: rgb(31, 73, 125);"><span style="">5)<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);">Would .NET Remoting
Service (whatever it is) be something to use<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 0.75in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="color: rgb(31, 73, 125);"><span style="">6)<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);">Apparently MS SQL
and MySQL seem to be the de facto databases of choice for web hosting
companies;
are their reasons why I would use one over the other. There is no cost
incurred
from the web host to use either.<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 0.75in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="color: rgb(31, 73, 125);"><span style="">7)<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);">I have done some
work with Visual Studio WinForms and a web application<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Sorry to
be such a bother. Again
thank you so much for helping me.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Charlie<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Williamson
GA<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 14pt; color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal">Hi<br>
<br>
I developed a Delphi web service (SOAP based) and delphi clients. This
worked fine but has the disadvantage of only running on Windows web
servers. This was of course the requirement for the next web job we
had. This time I used PHP for the web service and passed the data as
XML. I developed a system that can be used again and again for any web
site DB and table structure, however if I had not done this the task
would have
been very simple. I would strongly recommend using PHP for the web
side
of your service and then just use standard Delpi / indy for the client
side. It works well, is portable and fast. There are lots of PHP
examples on the web you can use. <br>
<br>
Hope that helps :)<br>
<br>
Rob <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style=""><span style="color: rgb(255, 153, 0);"
lang="EN-NZ"> </span><o:p></o:p></p>
<p class="MsoNormal" style=""><span lang="EN-NZ"> </span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><br>
<br>
Charlie wrote: <o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 14pt;">Hi, I would
appreciate any
recommendation you can give me about developing a web service and a
client
using Delphi. I have found some examples on the web but in each
instance I have
encountered errors when trying to compile or run the service.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 14pt;">Oh I’m using BDS
2006
Pro.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 14pt;">Thank you,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 14pt;">Charlie</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 14pt;"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 14pt;"> </span><o:p></o:p></p>
<p class="MsoNormal"><b><span
style="font-size: 14pt; font-family: Consolas; color: rgb(54, 95, 145);">Charlie
Kerscher</span></b><o:p></o:p></p>
<p class="MsoNormal"><b><span
style="font-size: 14pt; font-family: Consolas; color: rgb(54, 95, 145);">'A
Magisterium Faithful Catholic'</span></b><o:p></o:p></p>
<p class="MsoNormal"><b><span
style="font-size: 14pt; font-family: Consolas; color: rgb(54, 95, 145);">Williamson
GA</span></b><o:p></o:p></p>
<p class="MsoNormal"><b><span
style="font-size: 14pt; font-family: Consolas; color: rgb(54, 95, 145);">Cell:
770.468.1757</span></b><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<pre><o:p> </o:p></pre>
<pre style="text-align: center;">
<hr align="center" size="4" width="90%">
</pre>
<pre><o:p> </o:p></pre>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>NZ Borland Developers Group - Delphi mailing list<o:p></o:p></pre>
<pre>Post: <a moz-do-not-send="true"
href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><o:p></o:p></pre>
<pre>Admin: <a moz-do-not-send="true"
href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a><o:p></o:p></pre>
<pre>Unsubscribe: send an email to <a moz-do-not-send="true"
href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe<o:p></o:p></pre>
</div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: <a class="moz-txt-link-abbreviated" href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a>
Admin: <a class="moz-txt-link-freetext" href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a>
Unsubscribe: send an email to <a class="moz-txt-link-abbreviated" href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe</pre>
</blockquote>
</body>
</html>