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);
