Re: Getting results of a FOR Command

Mark Moss wrote:

Help


I can issue the following command in SQL


Select *
From Customer FOR XML AUTO
Where CustomerID = 19934590

But how do I get the results in my program?


Mark Moss

without knowing what RDBMS you use (not sure what FOR XML AUTO is
either) any select statement will return a set of records, and you can
have it loaded into a TADOQuery or TADODataset without problems using a
TADOConnection to connect to the database, assigning the command to
your dataset and executing it.


--
Best regards :)

Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam

.

Relevant Pages

  • Re: Remove letters in column
    ... String manipulation is a weak spot in SQL Server's command set. ... UPDATE Customer ...
    (microsoft.public.sqlserver.mseq)
  • Getting results of a FOR Command
    ... I can issue the following command in SQL ... From Customer FOR XML AUTO ...
    (borland.public.delphi.database.ado)
  • Re: Defeating The Top 1%; Request For Criticism
    ... The basic building block of all armies, such as the customer group, is ... The smallest group of soldiers organized to ... A platoon consists of 16 to 44 soldiers (2 ... concentrated within a single city neighborhood, would command a very ...
    (sci.econ)
  • Re: Organisational Forms Library
    ... I have used the code sample that you supplied attached to a Command ... Author of Configuring Microsoft Outlook 2003 ... When I said Customer I'm talking about internal ... -- For collaboration via the Internet, publish your form to your Personal Forms library. ...
    (microsoft.public.office.developer.outlook.forms)
  • Re: Organisational Forms Library
    ... Author of Configuring Microsoft Outlook 2003 ... I have used the code sample that you supplied attached to a Command ... When I said Customer I'm talking about internal ... -- For collaboration via the Internet, publish your form to your Personal Forms library. ...
    (microsoft.public.office.developer.outlook.forms)