Delphi 2005 + MSDE + WebService

Posted on 2006-04-06
Last Modified: 2010-04-05
I was asked to build an application which will be called from a existing program.

I have to do 3 main things:

1) Receive a parameter via command line. (Somewhere in the existing program, I will be called "MYPROGRAM 1234").
2) With the received parameter (1234 in the case)  I need to retrieve data in tables within a local MSSQL database.
3) With the data retrieved from tables I need to consume a Web Service passing formatted XML data.

I have Delphi 2005 Professional installed but never made an application with such kind of complexity.

Where do I start?
What kind of application will It be?
Is there an article or example?

Need help from some patient guy. It will be many questions...
Question by:jclobocar
    LVL 13

    Accepted Solution

    1) Receive a parameter via command line.

      if (ParamCount >0) then
    LVL 13

    Expert Comment

    to retrieve information from a database, you have to do a lot of reading, depending on your level of knowledge, but here you can find information from beginning to end:
    LVL 13

    Expert Comment

    3) With the data retrieved from tables I need to consume a Web Service passing formatted XML data.

    so you are going to take the data that comes out of the database, format it in XML, then pass it to a web service?

    if you are doing that, then that's a wrong approach, a web service in itself is formatted in XML

    do you have control over the web service?
    what parameters are expected from the web service?
    LVL 11

    Expert Comment

    If you want XML support, you might be better of with SQL Server Express which is Microsofts replacement for MSDE and is a restricted version of SQL Server 2005, it has much better XML handling

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
    Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
    This video discusses moving either the default database or any database to a new volume.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now