T
Thiru Malai
Guest
there is one table called gdmf_customer in progress database.In that table there is one field called shift time.Actually it has 15 records (06:00,07:00 and so on).Here i just buffer copied gdmf_customer to tt_data. In tt_data temp-table has field called tt_shift(whole datas comes from gdmf_customer after buffer copy).Now my question is i need to split shift hours and export as XML.See my codes below
FOR EACH gdmf_shift NO-LOCK:BUFFER-COPY gdmf_shift EXCEPT shift_obj TO tt_shift.END.
hOutSAXDocument:START-ELEMENT("Row").
hOutSAXDocument:INSERT-ATTRIBUTE("id","5").
hOutSAXDocument:START-ELEMENT("Column").
hOutSAXDocument:INSERT-ATTRIBUTE("id","C1").
hOutSAXDocument:WRITE-DATA-ELEMENT("Column",string(tt_orderinfo.shft_start_hour,"HH:MM")).
hOutSAXDocument:WRITE-DATA-ELEMENT("Column",string(tt_orderinfo.shft_stop_hour,"HH:MM")).
See from abouve codes i got first start and stop hours and expoerted as XML but what i need is every hours which is resides in tt_data. See Like this
Continue reading...
FOR EACH gdmf_shift NO-LOCK:BUFFER-COPY gdmf_shift EXCEPT shift_obj TO tt_shift.END.
hOutSAXDocument:START-ELEMENT("Row").
hOutSAXDocument:INSERT-ATTRIBUTE("id","5").
hOutSAXDocument:START-ELEMENT("Column").
hOutSAXDocument:INSERT-ATTRIBUTE("id","C1").
hOutSAXDocument:WRITE-DATA-ELEMENT("Column",string(tt_orderinfo.shft_start_hour,"HH:MM")).
hOutSAXDocument:WRITE-DATA-ELEMENT("Column",string(tt_orderinfo.shft_stop_hour,"HH:MM")).
See from abouve codes i got first start and stop hours and expoerted as XML but what i need is every hours which is resides in tt_data. See Like this
Continue reading...