Qlikview to Database

[rajni_batra]

heloo an u help me this:

created connection loaded table from SQL but need to revert back the status to DB after some changes,

How can i do this???

ODBC CONNECT TO SQL (XUserId is GAXEKXFMWLYAHYVOTLZEXEB, XPassword is LGGXNXFMWLYAHYVOTLZEXBC);

SQL

EXEC ReconDB.dbo.tblBookingComponentDetail ??????????

//

//A:

//SQL SELECT

//    "Booking ID",

//    "Component Type",

//    "Cost Price ",

//    ID,

//    "Selling Price ",

//    status

//FROM ReconDB.dbo.tblBookingComponentDetail;

//STORE * from A into recon.qvd;

Directory;

LOAD [Booking ID],

     [Component Type],

     [Cost Price ],

     if([Cost Price ]>30000 and [Cost Price ]<40000,'A',

      if([Cost Price ]>40000 and [Cost Price ] < 50000,'B','C')) as status,

     ID,

     [Selling Price ]

     FROM

recon.qvd

(qvd);