how do u spell intimidating - Updating sql database from an array

If calling a web service in Delphi is straightforward, the same can be said of developing a service.If you go into the Web Services page of the New Items dialog box, you can see the SOAP Server Application option.But in many cases this only provides a modest improvement as each UPDATE operation still requires a round-trip communication with the database server.

But before we get to the XML portion of the example, let me briefly discuss the database access section.

All the connectivity and SQL code in this example are hosted in a separate data module.

In the same unit that defines the interface of the service, you should also register it.

This operation will be necessary on both the client and server sides of the program, because you will be able to include this interface definition unit in both: type TConvert = class (TInvokable Class, IConvert) protected function Convert Currency (Source, Dest: string; Amount: Double): Double; stdcall; function To Euro (Source: string; Amount: Double): Double; stdcall; function From Euro (Dest: string; Amount: Double): Double; stdcall; function Types List: string; stdcall; end; The implementation of these functions, which call the code of the euro conversion system from Chapter 3, is not discussed here because it has little to do with the development of the service.

However, it is important to notice that this implementation unit also has a registration call in its initialization section: By registering the interface, you make it possible for the program to generate a WSDL description.

The web service application (since the Delphi 6.02 update) is capable of displaying a first page describing its interfaces and the detail of each interface, and returning the WSDL file.

OK, that’s great, we have some theoretical approaches for reducing the number of queries, now what?

The code required to implement the above logic is sufficiently fiddly that we would probably not want to have to repeat it.“value_columns” specifies the columns which will be updated (using SET).

The second element provides the value to be SET in the column specified by “value_columns”.

Tags: , ,