Icon View Incident Report

Serious Serious
Reported By: Malcolm Taylor
Reported On: 10/9/2009
For: Version 2.03 Build 4
# 3084 Exporting an Updateable View Causes All Rows to Be Exported from the Base Table

I am trying to export a subset of a table's records. It seemed I would have to use a view in order to limit the records .. but I must be doing it wrong.

This test script, run in the Manager, results in *all* records in "Events" being exported. I was expecting only matching records.

SCRIPT ()
BEGIN
  EXECUTE IMMEDIATE 'CREATE VIEW "LiveEvents" AS
                     SELECT *
                     FROM "Events"
                     WHERE "MeetRef"=1';
  EXECUTE IMMEDIATE 'EXPORT TABLE "LiveEvents"
                     TO "Events.txt"
                     IN STORE "DRBackup"';
  EXECUTE IMMEDIATE 'DROP VIEW "LiveEvents"';
END



Resolution Resolution
Fixed Problem on 10/11/2009 in version 2.03 build 5


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image