Field not found during STORE statement

rubinsky — Tue, 01 Nov 2011 18:35:19 GMT

Hi Folks, I'm trying the following and I'm not having much luck. Thank you.

LOAD VisitID,

Location,

Room,

Bed,

Room & '-' & Bed as RoomBed,

Account,

Patient,

reasonforvisit,

AdmissionDiagnosis,

AttendPhysician,

AdmitDateTime,

los,

/* UpdateDate, */

OrderSetUsed,

VTEProphMeds,

VTEMedsContra,

Device,

SurgeryDateTime,

SurgVTEProphMeds,

SurgVTEMedsContra,

SurgDevice,

PNVaccineEligible,

PNVaccineGiven,

FluVaccineEligible,

FluVaccineGiven,

OSUser() AS audituser,

ComputerName() AS auditworkstation,

Now() AS auditdatetime;

SQL SELECT *

FROM Tim.dbo."All_Test";

STORE Account, audituser, auditworkstation, auditdatetime, auditreport

FROM All_Test INTO AuditFile.qvd;

Results in

Field not found

STORE Account, audituser, auditworkstation, auditdatetime, auditreport

FROM All_Test INTO AuditFile.qvd

topic Field not found during STORE statement in QlikView