• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

18. XML > 18.7. Export Using a Where Clause

18.7. Export Using a Where Clause

Problem

You want to export a subset of rows in a table that match cartain search criteria instead of exporting the entire table.

Solution

There are two different approaches you can take, depending on how you want the output to look. The first approach is to design a query, and export the query to XML, as shown in the Solution in Recipe 18.5. The second is to use the ExportXML method. (You also could use an XSLT transform, but that would be inefficient unless you also need to format the data.)

The 18-07.MDB sample application has a saved query named qryCarsLessThan40. The SQL Select statement looks like this:

SELECT Car.CarID, Car.Make, Car.Model, Car.Price
FROM Car
WHERE (((Car.Price)<40000));

PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint