sql dynamic load data and union multiple tables

[Chernov]

hello,

1. i'll have sql query, and it work perfect, how i can convert it to QlikView-script ?

use SES

declare @operday int

set @operday='20130613'

select * from ChequeHead,ChequePos,ChequeDisc where ChequeHead.OperDay = @operday and ChequeHead.Id=ChequePos.ChequeId and chequepos.Id = chequedisc.PosId 

select * from ChequeHead,ChequePos,ChequeDisc where ChequeHead.OperDay = @operday and ChequeHead.Id=ChequePos.ChequeId and chequepos.Id = chequedisc.PosId 

select * from ChequeHead,ChequePos,ChequeDisc where ChequeHead.OperDay = @operday and ChequeHead.Id=ChequePos.ChequeId and chequepos.Id = chequedisc.PosId 

OR, i vave qv-script, and i want to select data from 4 tables, i have linked the tables by ID
I have one value OperDay, using it in the same table, I want to load only through SQL related rows in other tables of the first request, how i can do it?

and how you can update the data in the tables, if for example I will upload data each day, only changing the value of OperDay, or you can do this automatically using the Today (), converting it to Num ()

OLEDB CONNECT TO [Provider=SQLOLEDB.1;........

LOAD Id as [ChequeHeadID],

    Taken,

    Operation,

    ShopIndex,

    ShopIndexKKM,

    OperDay,

    "Cash_Code",

    NSmena,

    DateOperation,

    "Ck_Number",

    ControlTape,

    Cassir,

    Summa,

    SumNSP,

    "Disc_Sum",

    "MC_Date",

    "MC_Number",

    "MC_Depart",

    Status,

    StatusFiscal,

    Delivery,

    TransferReady,

    TransferComplete,

    ReturnNumber,

    CashKey,

    BuyerSum,

    DiscPercent,

    UpdateCounter,

    fsDocNumber,

    DefDiscount,

    FRNumber;

SQL SELECT Id,

    Taken,

    Operation,

    ShopIndex,

    ShopIndexKKM,

    OperDay,

    "Cash_Code",

    NSmena,

    DateOperation,

    "Ck_Number",

    ControlTape,

    Cassir,

    Summa,

    SumNSP,

    "Disc_Sum",

    "MC_Date",

    "MC_Number",

    "MC_Depart",

    Status,

    StatusFiscal,

    Delivery,

    TransferReady,

    TransferComplete,

    ReturnNumber,

    CashKey,

    BuyerSum,

    DiscPercent,

    UpdateCounter,

    fsDocNumber,

    DefDiscount,

    FRNumber

FROM SES.dbo.ChequeHead;

LOAD Id as [ChequePos],

    Taken,

    ChequeId  as [ChequeHeadID],

    "Ch_Pos",

    Quant,

    Price,

    "Ck_Curs",

    "Ck_CurAbr",

    GrCode,

    Code,

    NDSx1,

    NDSx2,

    Summa,

    SumNSP,

    NSPPrice,

    SalesMan,

    BarCode,

    BarCode1,

    "Disc_Summ",

    "Disc_SummNSP",

    CashKey,

    SizeScale,

    SizeScaleValue,

    PosSign,

    PosFound,

    PriceWithoutDisc,

    NSPPriceWithoutDisc,

    PriceCur,

    DiscPercent,

    GoodsUnit,

    GoodsName,

    UpdateCounter,

    PlaceNumber,

    ReservoirNo,

    NozzleNo,

    SessionId,

    FreeMode,

    DateOperation;

SQL SELECT Id,

    Taken,

    ChequeId,

    "Ch_Pos",

    Quant,

    Price,

    "Ck_Curs",

    "Ck_CurAbr",

    GrCode,

    Code,

    NDSx1,

    NDSx2,

    Summa,

    SumNSP,

    NSPPrice,

    SalesMan,

    BarCode,

    BarCode1,

    "Disc_Summ",

    "Disc_SummNSP",

    CashKey,

    SizeScale,

    SizeScaleValue,

    PosSign,

    PosFound,

    PriceWithoutDisc,

    NSPPriceWithoutDisc,

    PriceCur,

    DiscPercent,

    GoodsUnit,

    GoodsName,

    UpdateCounter,

    PlaceNumber,

    ReservoirNo,

    NozzleNo,

    SessionId,

    FreeMode,

    DateOperation

FROM SES.dbo.ChequePos;

LOAD Id as [ChequeDiscID],

    PosId  as [ChequePosID],

    Taken,

    DiscType,

    DiscId,

    CardNumber,

    DiscSumm,

    DiscSummNSP,

    CashKey,

    Quantity,

    DiscQueue,

    ApplyToPos,

    DiscPercent,

    Price,

    NSPPrice,

    UpdateCounter;

SQL SELECT Id,

    PosId,

    Taken,

    DiscType,

    DiscId,

    CardNumber,

    DiscSumm,

    DiscSummNSP,

    CashKey,

    Quantity,

    DiscQueue,

    ApplyToPos,

    DiscPercent,

    Price,

    NSPPrice,

    UpdateCounter

FROM SES.dbo.ChequeDisc;

LOAD Id as [ChequePay],

    Taken,

    ChequeId  as [ChequeHeadID],

    DocType,

    DocDate,

    DocNumber,

    DocSumm,

    Status,

    PayType,

    CashKey,

    PaySumCur,

    CurCode,

    UpdateCounter,

    PayDocRate;

SQL SELECT Id,

    Taken,

    ChequeId,

    DocType,

    DocDate,

    DocNumber,

    DocSumm,

    Status,

    PayType,

    CashKey,

    PaySumCur,

    CurCode,

    UpdateCounter,

    PayDocRate

FROM SES.dbo.ChequePay;

[Anonymous]

Hi,

I am testing another barcode reader these days. I wonder wether it can help you. I hope you success. Good luck.

Best regards,

Pan