• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 160
  • Last Modified:

Delphi 2005 + MSDE + WebService

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...
0
jclobocar
Asked:
jclobocar
  • 3
1 Solution
 
BlackTigerXCommented:
1) Receive a parameter via command line.

var
  yourparam:string;
begin
  if (ParamCount >0) then
    yourparam:=ParamStr(1);
0
 
BlackTigerXCommented:
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:
http://delphi.about.com/od/database/a/databasecourse.htm
0
 
BlackTigerXCommented:
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?
0
 
pcsentinelCommented:
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
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now