Re: [DUG] Delphi Web Service & Client

[Robert martin]

Hi I have been following your project :) 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).  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 1. A web site / ordering system 2. A transfer app to transfer data to and from the web DB.  This step was what I referred to in my previous email. my answers to your # questions 1. Yes, you know Delphi so thats one less thing to learn. 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. 3. Yes.  There are lots of options. The one above is simple. 4.  Not required for task.  Good idea to. 5. Don't know about it.  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 :) 7. Thats nice :)  you could make your web site using that if you want ! Cheers Rob       Charlie wrote: Rob, thanks so much for the reply. 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. Can I ask you another question. Or a couple? 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. Any course of action will require a huge learning curve for me. My only source of help is forums like this. Given this 1)      Should I continue with Delphi 2)      and dBase 3)      Are there better ways than web services to allow customers to enter their own orders 4)      If I continue with Delphi should I upgrade to RAD Studio 2010 5)      Would .NET Remoting Service (whatever it is) be something to use 6)      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. 7)      I have done some work with Visual Studio WinForms and  a web application Sorry to be such a bother. Again thank you so much for helping me. Charlie Williamson GA       Hi 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.  Hope that helps :) Rob       Charlie wrote: 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. Oh I’m using BDS 2006 Pro. Thank you, Charlie     Charlie Kerscher 'A Magisterium Faithful Catholic' Williamson GA Cell: 770.468.1757       _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe

_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi@delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: 
unsubscribe