<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)">
<!--[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]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>Rob, thanks so much for the
reply. <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>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:#1F497D'>Can I ask you another question.
Or a couple?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>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:#1F497D'>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:.75in;text-indent:-.25in;
mso-list:l0 level1 lfo2'><![if !supportLists]><span style='color:#1F497D'><span
style='mso-list:Ignore'>1)<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#1F497D'>Should I continue
with Delphi<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:.75in;text-indent:-.25in;
mso-list:l0 level1 lfo2'><![if !supportLists]><span style='color:#1F497D'><span
style='mso-list:Ignore'>2)<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#1F497D'>and dBase<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:.75in;text-indent:-.25in;
mso-list:l0 level1 lfo2'><![if !supportLists]><span style='color:#1F497D'><span
style='mso-list:Ignore'>3)<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#1F497D'>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:.75in;text-indent:-.25in;
mso-list:l0 level1 lfo2'><![if !supportLists]><span style='color:#1F497D'><span
style='mso-list:Ignore'>4)<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#1F497D'>If I continue with
Delphi should I upgrade to RAD Studio 2010<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:.75in;text-indent:-.25in;
mso-list:l0 level1 lfo2'><![if !supportLists]><span style='color:#1F497D'><span
style='mso-list:Ignore'>5)<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#1F497D'>Would .NET Remoting
Service (whatever it is) be something to use<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:.75in;text-indent:-.25in;
mso-list:l0 level1 lfo2'><![if !supportLists]><span style='color:#1F497D'><span
style='mso-list:Ignore'>6)<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#1F497D'>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:.75in;text-indent:-.25in;
mso-list:l0 level1 lfo2'><![if !supportLists]><span style='color:#1F497D'><span
style='mso-list:Ignore'>7)<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#1F497D'>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:#1F497D'>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:#1F497D'>Charlie<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Williamson GA<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:14.0pt;color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><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='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-NZ style='color:#FF9900'> </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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:14.0pt'>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:14.0pt'>Oh I’m using BDS 2006
Pro.</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:14.0pt'>Thank you,</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:14.0pt'>Charlie</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:14.0pt'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:14.0pt'> </span><o:p></o:p></p>
<p class=MsoNormal><b><span style='font-size:14.0pt;font-family:Consolas;
color:#365F91'>Charlie Kerscher</span></b><o:p></o:p></p>
<p class=MsoNormal><b><span style='font-size:14.0pt;font-family:Consolas;
color:#365F91'>'A Magisterium Faithful Catholic'</span></b><o:p></o:p></p>
<p class=MsoNormal><b><span style='font-size:14.0pt;font-family:Consolas;
color:#365F91'>Williamson GA</span></b><o:p></o:p></p>
<p class=MsoNormal><b><span style='font-size:14.0pt;font-family:Consolas;
color:#365F91'>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 size=4 width="90%" align=center>
</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
href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><o:p></o:p></pre><pre>Admin: <a
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
href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe<o:p></o:p></pre></div>
</body>
</html>